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.
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.
Re: How to apply applying filter/selection based input box selection
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: