Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
khigaurav999
Contributor

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

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

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
New Contributor III

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

Hi Gaurav,

use interval-match to achieve this.

Regards

Anvesh

khigaurav999
Contributor

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

Thanks, Anvesh. you mean slider object?

rahulpawarb
Valued Contributor III

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

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