Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
gonzaloyaguesun
New Contributor III

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
gonzaloyaguesun
New Contributor III

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

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

Partner
Partner

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

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..