Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
LDR
Creator II
Creator II

Bar chart - Range - Customized according main measure and/or alternative measure

Hi everyone,

I have a bar chart with two measures (the main and the alternative one). I'd like to set a customized max range depending the selected measure.

I tried to use functions like GetObjectMeasure() without luck. You know something like that:

If(GetObjectMeasure()=1,0.1,500)

My intention is to use the standard features included in the Bar Chart.

Thanks in advance

Labels (3)
2 Replies
justISO
Specialist
Specialist

Hi, GetObjectMeasure() is giving not a number, but name of measure (label) in text string format. So your approach with it should work, but try to modify formula to something like this:

If(GetObjectMeasure()='Measure1',0.1,500)

where Measure1 is your first measure name/label.

LDR
Creator II
Creator II
Author

Hi, Sorry was my mistake when I wrote the entry in the forum. My tests were comparing the result of GetObjectMeasure() vs the measure's name.  It didn't work.

LDR_1-1658127479928.png

It didn't work inside max range fx:

LDR_2-1658127539017.png

Regards