how to insert a filter in a chart

[gianluca_brick]

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 

 

[BrunPierre]

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.

[gianluca_brick]

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?

[gianluca_brick]

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

[gianluca_brick]

Hi,

I solved use this formula:

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

Regards