Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Max and Min values of Y-axis change with alternative measures (Qlik Sense)

Dear all,

I have a bar chart with one dimension and two measures (one of them is alternative). Is it possible to change dinamically the maximum and minimum values of Y-axis when  displaying one measure or the other one. For example, when displaying measure1 values of y-axis should range from -200 to 100 and range from -100 to 300 when displaying measure2.


Is it possible to achieve it?

Thank you very much in advance.

Best regards,

Gonzalo

2 Replies
Anonymous
Not applicable
Author

I know how to set máximum and mínimum values of y-axis if I didn't have alternative measures.

OmarBenSalem

you don't use alternative measures to do this, but instead create an inline table as follow:

load * inline [

MeasureID, Measure

1, YourFirstMeasure

2, YourSecondMeasure

];

now, add this new Measure filed as a fitter in ur dashboard;

in ur chart, as measure:

if(MeasureID=1, sum(Measure1), sum(Measure2))  , with that, if u select from ur filter, YourFirstMeasure, u'll have sum(Measure1) etc..

same approach to build the min and max values with if conditions

example:

Capture.PNG

for min:

if (MeasureID=1,-200,0)

max:

if(MeasureID=1,500,2000)

and u can always make ur chart clearer; by adding a condition in ur adds on, count(distinct MeasureID)=1

with that, u force a selection of one measure only !

and add this information in your chart title, for example

=Measure&' by year'

with that, u'll know, what measure u're using in the chart..

and maybe same approach in the expression label

hope that was clear..