Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.