topic Re: How to apply applying filter/selection based input box selection in QlikView

How to apply applying filter/selection based input box selection

khigaurav999 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community Members & Friends,

I am new to QlikView. I have a question on - how can I use variable selection to apply selection on a particular field? In my QV doc, I have a list box (i.e. AGE field list box below) and created a variable input box with variable values from A Week to A Year and a Refresh button as mentioned in below screenshot.

Basically what I want is - for example when user selects A Week in CR Aging Filter input box object and click on Refresh button, it should apply selection on field AGE as AGE >=7 and similarly other options:

For 2 Weeks selection should be AGE >=14
For 2 Weeks to 3 Weeks selection should be AGE >=14 AND AGE <=21
For A Year selection on the Age field should be AGE>=365

I know to achieve it to some extend user can type on List Box itself (AGE>7) and get it but i want to make it more easier for user.

Please help me to achieve this. And let me know if there are any other better ways to achieve it with a compelling user experience.

Thanks,

Gaurav

Message was edited by: Gaurav Khinchi

Re: How to apply applying filter/selection based input box selection

Fri, 03 Mar 2017 12:08:09 GMT

In Button actions choose your field as Age and
Search String use some thing like below

=if(InputVar='A Week','<=14',

if(InputVar ='2 Weeks','>=14<=21',

IF(InputVar = 'A Month','<=30','<=365')

)

Re: How to apply applying filter/selection based input box selection

Anvesh — Fri, 03 Mar 2017 12:10:23 GMT

Hi Gaurav,

use interval-match to achieve this.

Regards

Anvesh

Re: How to apply applying filter/selection based input box selection

khigaurav999 — Fri, 03 Mar 2017 12:28:09 GMT

Thanks, Anvesh. you mean slider object?

Re: How to apply applying filter/selection based input box selection

rahulpawarb — Fri, 03 Mar 2017 12:52:41 GMT

Hello Gaurav,

Considering CR Aging Filter has Aging variable. Open Button properties and go to Action Tab. Click Add button, select Selection as Action Type & Select in Field as Action. In Filed text box add Age and under the Search String add below expression:

= If(Aging='A Weeks', '<=' & 7,
If(Aging='2 Weeks', '>=' & 8 & '<=' & 14,
If(Aging='2 Weeks to 3 Weeks', '>=' & 15 & '<=' & 21,'>=' & 22)))

Hope this will help.

Regards!

Rahul