show hide bars in a chart using conditional expression

[RicardoVD97]

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!

[RafaelBarrios]

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,

[Ryan69]

---

@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.

[RafaelBarrios]

hi @Ryan69 

try the example below

[elainao]

---

@RafaelBarrios wrote:

hi @Ryan69  Five Nights at Freddy's

try the example below

---

You are welcome, I am happy to help out