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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

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
Follow me on my LinkedIn | Know IPC Global at ipc-global.com