Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
npatel1
Contributor II
Contributor II

Combo chart - Height of line based on nested if condition- Data Formatting issues

I have a combo chart.

Height of line is based o following condition:

if('$(vmeasure)'='1',[ASP per Kg],if('$(vmeasure)'='2',[Gross Margin %]*100,if('$(vmeasure)'='3',[GP per MT],'-')))

 

Note: vmeasure is a master variable.

 

Question: I want the data points format to change based on the vmeasure value.

So if vmeasure = 1 (ASP per KG), I want number format to display upto 2 decimals-1000.00

if vmeasure = 2 (Gross Margin %), I want number format to display in percentage- %

So if vmeasure = 3 (GP per MT), I want number format to display with no decimals-1000

npatel1_2-1721683538514.png

 

 

 

 

 

 

Labels (5)
1 Reply
marksouzacosta
Partner - Specialist
Partner - Specialist

Change the Number format to Measure expression and try to set the format inside your Master Measures:

marksouzacosta_0-1721696721801.png

 

Read more at Data Voyagers - datavoyagers.net