topic Re: How to select filter values based on Variable dropdown in App Development

How to select filter values based on Variable dropdown

vish123 — Tue, 30 Nov 2021 18:17:33 GMT

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.

Re: How to select filter values based on Variable dropdown

Mark_Winter — Fri, 25 Jun 2021 10:38:34 GMT

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

Re: How to select filter values based on Variable dropdown

vish123 — Fri, 25 Jun 2021 11:30:01 GMT

Hi Snowy,

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

Re: How to select filter values based on Variable dropdown

Mark_Winter — Fri, 25 Jun 2021 11:34:21 GMT

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

Re: How to select filter values based on Variable dropdown

vish123 — Fri, 25 Jun 2021 11:52:17 GMT

Hi Snowy,

Thanks, Let me try and get back to you.