Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart that has multiple lines. I need to assign each line a specific color. I have gone to "Custom: Colors & Legend" then chose "Expression" . In Expression I wrote:
If(Sum([Sales Actuals])>'0', RGB(59, 147, 65)) ,
If (Sum([Cost Actuals])>'0', RGB(200, 17, 165)) ,
If (Sum([Sales Planned])>'0', RGB(156, 100, 105)) ,
If (Sum([Cost Planned])>'0', RGB(250, 15, 75)) ,
If (Sum([Total])>'0', RGB(24, 60, 200))
What is the correct syntax to assign each measure its own color? Or how can I assign each measure its own color?
Qlik Sense
You are closing conditions immediately to the IF where as it required in the end, like
If(Sum([Sales Actuals])>'0', RGB(59, 147, 65), If (Sum([Cost Actuals])>'0', RGB(200, 17, 165),
If (Sum([Sales Planned])>'0', RGB(156, 100, 105), If (Sum([Cost Planned])>'0', RGB(250, 15, 75),
If (Sum([Total])>'0', RGB(24, 60, 200))))))
You are closing conditions immediately to the IF where as it required in the end, like
If(Sum([Sales Actuals])>'0', RGB(59, 147, 65), If (Sum([Cost Actuals])>'0', RGB(200, 17, 165),
If (Sum([Sales Planned])>'0', RGB(156, 100, 105), If (Sum([Cost Planned])>'0', RGB(250, 15, 75),
If (Sum([Total])>'0', RGB(24, 60, 200))))))
Thanks!!!! That worked.