Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khigaurav999
Creator
Creator

How to apply applying filter/selection based input box selection

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.

temp12.jpg

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

4 Replies
Not applicable

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')

  )

)

age.PNG

Anvesh
Contributor III
Contributor III

Hi Gaurav,

use interval-match to achieve this.

Regards

Anvesh

khigaurav999
Creator
Creator
Author

Thanks, Anvesh. you mean slider object?

rahulpawarb
Specialist III
Specialist III

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