Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Cascader
Creator
Creator

how to keep bar chart looks consistent even if the scale changed?

Hi

how can I keep bar step 0 seems equal even if the scale has changed in the following bar chart. 

example.jpg

Labels (2)
4 Replies
vchuprina
Specialist
Specialist

Hi,

You can set min and max values of your scale. You can hardcode them or determine min/max by using some expressions. In my example, I use Min({1}Measure), Max({1}Measure), so bars always keep proportion to the min and max value in the dataset

vchuprina_0-1650441103907.png

All values:

vchuprina_1-1650441529119.png

without C

vchuprina_2-1650441575369.png

Also, it works in the same way in Qliksense

vchuprina_3-1650441853110.png

Regards,
Vitalii

 

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
Cascader
Creator
Creator
Author

seems logical vitallii, however not worked for me, instead of Measure, I use an expression 

vchuprina
Specialist
Specialist

Could you please share your expression?

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
Cascader
Creator
Creator
Author

SET exp.ZeroBarHeightDay = -RangeMax(Avg(Total <Department> Target), 0.05);