Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
NewToQlik
New Contributor III

Hiding bar chart measure

Hi all,

Capture.PNG
I have a barchart, where there are 8 measures. The measures will be shown when users select a corresponding filter for each measure. I want to hide the measure completely, instead of showing '-' and the empty colors in the legend.

I was able to do it in a table with the 'Show column if' property. Is there something similar for the bar chart? Thanks for the help.

Labels (2)
6 Replies
MVP & Luminary
MVP & Luminary

Re: Hiding bar chart measure

Nope, that options is not yet available for bar charts. You could try using a synthetic dimension using the valuelist function and one expression:

Dimension: =ValueList('SumOfA', 'SumOfB', 'SumOfC')
Expression: =Pick(Match(ValueList('SumOfA', 'SumOfB', 'SumOfC'), 'SumOfA', 'SumOfB', 'SumOfC'), sum(A), sum(B), sum(C))

talk is cheap, supply exceeds demand

Re: Hiding bar chart measure

I can suggest to create island table and associate to Measure which applicable auto associate to Entire model

Else, I can think to drag using Load statement with flag and doing concatenate.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
NewToQlik
New Contributor III

Re: Hiding bar chart measure

Using the valuelist() method, will I be able to use 'Gender' as a dimension?

Re: Hiding bar chart measure

You can use, But Valuelist() always will show static which is not associate to Model. You don't like my option to showcase?

That means, For gender dimension Each row will produce three rows from ValueList()

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
NewToQlik
New Contributor III

Re: Hiding bar chart measure

Can I take a look at an example so that I can understand better?

Re: Hiding bar chart measure

Can you please post sample application

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)