Bar chart filter condition are not working

[govindvasu]

Hi Good morning,

I have the bar chart with the below data.

Empid      Year            Status

1                   2021            High

1                    2022            Low

1                     2023            Medium

2                     2021             Avg

2                      2022           BelowAvg

2                       2023            Low

3                  2021            High

3                    2022            Low

4                     2023            Medium

5                     2021             Avg

5                      2022           BelowAvg

5                       2023            Low

I have these filters on my filter pane 

 

and this is how the final visualization looks  all the filter condition are working fine

When I take the subset of the data and plot the stacked bar chart only for the Avg and below average status the filter pane options are not working. For example If i select Year as 2022 the bar chart of subset data still looks the same it is not changing. This is how it looks like.

Result:

The filter pane has to work on both complete data and subset data. Can anyone help me on this?

Thanks in advance

[justISO]

Hi, how you make subset data for avg and bellowavg only? Using set analysis?

[Aditya_Chitale]

Can you share the set expression you are using ? 

Regards,

Aditya

[govindvasu]

This is the set analysis i am using for getting the subset of data
count({<Status={'Avg','BelowAvg'}>}distinct Empid)

Below is the set analysis for all the data

count(distinct Empid)

[govindvasu]

This is the set analysis i am using for getting the subset of data
count({<Status={'Avg','BelowAvg'}>}distinct Empid)

Below is the set analysis for all the data

count(distinct Empid)

[justISO]

I don't see why the graph shouldn't work with filter in this way. Expression is correct. Except that I, as a user of not latest Qlik  version (and not SaaS), have not seen such filter with checkbox possibility. Is it official 'filter pane'?

[govindvasu]

Yes this is the official filter pane