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