topic show hide bars in a chart using conditional expression in App Development

show hide bars in a chart using conditional expression

RicardoVD97 — Tue, 18 Oct 2022 18:12:52 GMT

Hi comunnity!

I'm working on Qlikview migration to Qliksense, I have some charts with this condition where the bars are hide, but when user selects the year in filter pine tool, the bars are shown so you can see the difference between two dimensions.

I'm trying to replicate this operation in Qliksense but I have not fount the solution. I have use "Data handling" option, but it only let me do it with all the chart, not only an especific dimensions. Here are some images from the charts and expressions, thanks!

Re: show hide bars in a chart using conditional expression

RafaelBarrios — Tue, 18 Oct 2022 19:35:56 GMT

HI @RicardoVD97

i think this is not available by default

but, you can try this

1. create a variable vSetMeasure

2. create master measures, for me i will create Quantity Delivery, Quantity Planned, Quantity Sent, Quantity Produced

3. Create a variable object

and config as follow

Dynamic Values
='[Quantity Delivery]~Delivery|[Quantity Planned]~Planned|[Quantity Sent]~Sent|[Quantity Produced]~Produced'

4. to your bar chart object set dimension you need

5. in bar chart, use the following as measure

=$(vSetMeasure)

and you could use this as title

='$(vSetMeasure)'

6. Set a default for your variable so always shows something

hope this works for you.

best,

Re: show hide bars in a chart using conditional expression

Ryan69 — Wed, 19 Oct 2022 07:35:05 GMT

@RicardoVD97 wrote: Dashboard Anywhere Chrysler

Hi comunnity!

I'm working on Qlikview migration to Qliksense, I have some charts with this condition where the bars are hide, but when user selects the year in filter pine tool, the bars are shown so you can see the difference between two dimensions.

I'm trying to replicate this operation in Qliksense but I have not fount the solution. I have use "Data handling" option, but it only let me do it with all the chart, not only an especific dimensions. Here are some images from the charts and expressions, thanks!

I'm also facing the issue, please help me to resolve this issue.

Re: show hide bars in a chart using conditional expression

RafaelBarrios — Wed, 19 Oct 2022 08:18:01 GMT

hi @Ryan69

try the example below

Re: show hide bars in a chart using conditional expression

elainao — Tue, 28 Feb 2023 04:25:14 GMT

@RafaelBarrios wrote:

hi @Ryan69 Five Nights at Freddy's

try the example below

You are welcome, I am happy to help out