Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

waydec_ses
New Contributor III

Hiding non-associated entries in bar charts when using filters

Hi,

I must be missing something here or maybe the standard QS bar chart just doesn't do it easily.

A user wants to show all audit categories on a stacked bar chart along with the count of measures by status (which in the chart below are color-coded).

Bar Chart Issue LE.PNG

When the user makes a filter selection, they want any audit categories that are not associated with a filter selection to be hidden on the bar chart.  In the chart below, once the filter is selected, these have changed to black.  The black ones are the audit categories we want hidden.

Bar Chart Issue LE FAM Filter.PNG

I know this is possible with a pivot table, but is it possible with a stacked bar chart and if so, how can it be done?

Kind regards,

Wayde

3 Replies
kkkumar82
Valued Contributor III

Re: Hiding non-associated entries in bar charts when using filters

I think the black ones are also the associated ones as they are coming up with some values , but according to your question when there are no associated values for a selection they shouldn't come up ,this is strange

agigliotti
Honored Contributor II

Re: Hiding non-associated entries in bar charts when using filters

what is your chart measure and what is your field selections ?

waydec_ses
New Contributor III

Re: Hiding non-associated entries in bar charts when using filters

Hi Andrea and Kiran,

Based on your comments, I checked out the measure created by the user, removed the set analysis expression and created a conditional sum(if(..., 1,0)) expression.  Selection using an associated filter now shows the relevant audit categories on the stacked bar chart.

Thank you both for your contributions and time.

Wayde

Community Browser