Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vish123
Creator III
Creator III

How to select filter values based on Variable dropdown

Hi Team,

I have below requirement. For instance if i select one month from dropdown it should select "Mar 21" from filter , in case "3 months" then it should select "Mar 21, Jan -21, Aug-20 " so on.. any one has any idea about how to implement this in Qlik Sense. Any inputs are greatly appreciated. Thank you . Please find the screen shot of the same.

vish123_0-1624540416129.png

 

Labels (1)
4 Replies
Mark_Winter
Creator
Creator

Hi, though it's not using a dropdown, button field selections can achieve this.

 

SnowyOwl_3-1624617458229.pngSnowyOwl_4-1624617484789.pngSnowyOwl_5-1624617506874.png

 

vish123
Creator III
Creator III
Author

Hi Snowy,

Thanks for your reply. Can you please let me know the button logic please?

Mark_Winter
Creator
Creator

In my given example, making use of:

Max(Num)

'$(=Max(Num)-2);$(=Max(Num)-1);$(=Max(Num))'

'$(=Max(Num)-5);$(=Max(Num)-4);$(=Max(Num)-3);$(=Max(Num)-2);$(=Max(Num)-1);$(=Max(Num))'

vish123
Creator III
Creator III
Author

Hi Snowy,

Thanks, Let me try and get back to you.