QlikView App Dev

[khigaurav999]

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

[#2]

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

  )

)

[Anvesh]

Hi Gaurav,

use interval-match to achieve this.

Regards

Anvesh

[khigaurav999]

Thanks, Anvesh. you mean slider object?

[rahulpawarb]

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