topic Re: Want to create value range in qlikview in QlikView

Want to create value range in qlikview

qliklearnervir — Wed, 12 Aug 2015 07:39:17 GMT

I Have created one list box having week number from start date to date range .

Week are showing as 1 to 50.

I want to create a input box and want to set any value like 22 than list box sshould show 22 weeks number from 1 to 22 and vice versa.

KIndly suggest how it possible while selecting range in qlikview list box for numbers.

sunny_talwar — Wed, 12 Aug 2015 07:46:05 GMT

May be use a list box expression like this:

If(vVar <= Week, Week)

If(vVar >= Week, Week)

Where vVar is where you input the value (like 22)

Anonymous — Wed, 12 Aug 2015 07:49:46 GMT

maybe a slider would be a good choice for most enduser?

you can select startweek and number of weeks (mulit value mode)

but slider takes more space

qliklearnervir — Wed, 12 Aug 2015 08:45:29 GMT

but i want to select 1 to 22 ....not only 22 ....suggest