topic Re: how to insert a filter in a chart in QlikView

how to insert a filter in a chart

gianluca_brick — Mon, 05 Sep 2022 15:48:00 GMT

Hi, I have this table in qlikview and I would like to filter by the field "Data Ultimo SContrino" = '-' how do I do? is there any way to do it from the conditions of the chart?

regards

Gianluca

Re: how to insert a filter in a chart

BrunPierre — Mon, 05 Sep 2022 20:59:14 GMT

Perhaps in a pivot table as illustrated below. On the other hand, you may have to textualize '-' (null or missing values) to be displayed by the dropdown.

Re: how to insert a filter in a chart

gianluca_brick — Tue, 06 Sep 2022 07:21:15 GMT

Hi,

actually I should filter on a bar chart where as an expression. I execute a count (Card_Code) and I should filter by "Last Receipt Date" is null or "-". How can I filter on the bar chart?

Re: how to insert a filter in a chart

gianluca_brick — Tue, 06 Sep 2022 08:43:21 GMT

I solved with the following formula in the expression:
Count ({<DATA_MAX_ULTIMO_BONTRINO_3 = {'13/05/2021'}>} K_MEMBER_3)

If I want to filter for the '-' values it doesn't work, what do you recommend?:

Count ({<DATA_MAX_ULTIMO_BONTRINO_3 = {'-'}>} K_MEMBER_3)

that should be a null value

Re: how to insert a filter in a chart

gianluca_brick — Tue, 06 Sep 2022 09:50:30 GMT

Hi,

I solved use this formula:

count(IF(IsNull(DATA_MAX_ULTIMO_SCONTRINO_3),(K_MEMBER_3)))

Regards