how to set different color for each lines in chart

[sdtfll]

masterTable:

load * inline [

name,qty,value

grant,11,12

sunny,13,19

bob,9,16 ];

draw this masterTable in chart and have two lines named: "qty", "value",

I want to set different color for them by formulars,

how to write such formular?

just like

if(line_name = 'qty', 'red', 'white')

[Mark_Little · Accepted solution]

Hi @sdtfll 

Sadly i don't believe you can colour it that way. 

You would need to set them up as Master Measures and then choose the colours there.

[sdtfll]

thanks,