Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
firoz24
Creator
Creator

Qlik sense range

Hi Guys,

I want my y axis range set to this set analysis in a bar chart 

max([Mileage Range]) +10 

I cant use auto because the total label in a first bar in bar chart is not visible

so When I filter the max value in a field and +10 should be added so that the total label in first bar will be visible.

Labels (6)
1 Solution

Accepted Solutions
MayilVahanan

HI

Your exp is count([VP report date]), 

so in that case try like below

Max(Aggr( count([VP report date]), urchartdimension)) + 10

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

10 Replies
LRuCelver
Partner - Creator III
Partner - Creator III

You can change the range here:

LRuCelver_0-1710317792362.png

 

firoz24
Creator
Creator
Author

Hi Lreclever,

Thanks for your reply,

yes the max([Mileage Range]) is working but the +10 is not working please check it should work according to the selection in filter pane.

firoz24
Creator
Creator
Author

Hi LRuclever,

Actually Its not working I have a field called mileage range, so, the max value of the bar chart  should calculate and add it with +10 

LRuCelver
Partner - Creator III
Partner - Creator III

Try using this:

Max(Aggr(<Your Chart Measure>, <Your Chart Dimension>)) + 10
firoz24
Creator
Creator
Author

No Lruclever,

Still not working I am just getting max value but the +10 is not working if i filter something the range goes according to the max value in a bar chart.

qv_testing
Specialist II
Specialist II

Try this

 RangeSum(max([Mileage Range]), 10)

Dataintellinalytics

Please share snapshot for better understanding.

firoz24
Creator
Creator
Author

firoz24_0-1710471265660.pngfiroz24_1-1710471310161.png

firoz24_2-1710471360208.png

firoz24_3-1710471391742.png

This are the set analysis used in this bar chart 

 

MayilVahanan

HI

Your exp is count([VP report date]), 

so in that case try like below

Max(Aggr( count([VP report date]), urchartdimension)) + 10

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.