Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.