Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Qlik Sense dashboard (version Feb 2020) that I am building. One of the requirements is to have values less then 0 have a red background. The issues with this is I am using a static inline column to put the values in. The calculations I am using are very long and complicated and would prefer not to have to copy them into the background expression to make the color change. Here is a simplified version of what I am trying to accomplish.
The Data expression is like this:
if (MyRow='Row cars sold', Some calculation 1,
if (MyRow='Row Cars Traded In', Some calculation 2,
if (MyRow='Row Cars Salvaged', Some calculation 3,
If (MyRow='Row Cars Kept', Some calculation 4,
))))
I have tried the following to change the background color but none of them work. Is there something else I could try?
if ('MyRow' < 0 , Red(), Green())
if (Column(2) < 0, Red(), Green())
if ('[Cars Sold]' < 0 , Red(), Green())
you can reference the expression's label.
is that what Cars Sold is? if so, it wouldn't be in single quotes
if ([Cars Sold] < 0 , Red(), Green())
Also column(<measure index>) would work also. but maybe it wasnt #2. you put in the measure number, don't count the dimensions. maybe column(1) would have worked.
I apologize, I forgot to mention this is in a simple table.
you can reference the expression's label.
is that what Cars Sold is? if so, it wouldn't be in single quotes
if ([Cars Sold] < 0 , Red(), Green())
Also column(<measure index>) would work also. but maybe it wasnt #2. you put in the measure number, don't count the dimensions. maybe column(1) would have worked.
Thank you Stevejoyse this worked!!