topic Re: Button filter in QlikView

Button filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a gauge field, which displays a count for a below table. (Expression: =count(if(NEED_BY_DATE < date(today()),0)))

Can I have it so that if I click the gauge output (like a button) it will filter the below table to just show that results for that count?

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 09:59:10 GMT

Hi,

you can set an action to set a value (your expression value) into a variable, and use that variable in a set analysis on the expression of the table below.

Re: Button filter

Anonymous — Fri, 18 May 2018 10:02:02 GMT

Would you be able to provide an example of how to do this?

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 10:02:54 GMT

Give me a set of data and I'll try to give you an example

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 10:03:53 GMT

or if you can't, just tell me and I'll try to create it for you

Re: Button filter

Anonymous — Fri, 18 May 2018 10:15:38 GMT

Example Attached

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 10:18:03 GMT

So using the image below, what are you trying to select and what is your expected output ?

Re: Button filter

Anonymous — Fri, 18 May 2018 10:22:25 GMT

I am trying to select the overdue '4' so that it will only return the 4 red dates in the table. I would like the same for the orders within lead time, when you select the '6' the table will only show those results in the table.

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 10:28:12 GMT

Please find attached

Re: Button filter

Anonymous — Fri, 18 May 2018 10:36:21 GMT

Is it only the actions in the gauge box all you changed? If so, this is not working on mine

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 10:38:37 GMT

created an action and changed the expression on the table

Re: Button filter

Anonymous — Fri, 18 May 2018 10:45:30 GMT

Got it! Thank you so much!

Re: Button filter

YoussefBelloum — Fri, 18 May 2018 11:10:55 GMT

You're welcome, good luck