Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Make a bar static in Bar chart

I have a stacked bar chart with two dimensions (one of them is Cyclic Group) and 4 expressions.  Clicking on the dimensions drill down into next level cyclic groups. And clicking on any bars shows that one specific bar. 

 

Is there a way to make one bar out of those 4 bars static? Meaning no matter what selections are made on other fields or dimensions within the chart, that one bar should always appear while the other bars change as per selections.

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

Can you not exclude the selections via set? like below

sum({<Field1,Field2>}Sales)

View solution in original post

4 Replies
Kushal_Chawda

Can you share expected screenshot of Bar?

qlikwiz123
Creator III
Creator III
Author

This is first level in Dimension Cyclic Group:

 

qlikwiz123_0-1596326550102.png

So when I drill down on the dimensions or make any other selections on other fields in the Dashboard, the last bar (BCYJKY) should always stay. This is because the BCYJKY bar data is not connected to other columns and hence when I make any selection on other fields, it disappears. I need to make that one bar static no matter what selections a user makes and thus that bar should always appear even if other bars drill down or change.

 

Kushal_Chawda

Can you not exclude the selections via set? like below

sum({<Field1,Field2>}Sales)

MK9885
Master II
Master II

Maybe use IF condition?
What is your backend expression?

What dimensions do you have?