Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is, in Qliksense text & image box, when value is in +ve, it will show in green (1000+) and when value is in -ve then it will show in red (150-).
current output:
1000+ Current Month (Dec 2017) 150- Last Month (Nov 2017) |
Expected output:
1000+ Current Month (Dec 2017) 150- Last Month (Nov 2017) |
Hi Anil, for that format I think you will need 2 expressions for each row, one for text in red and other in green.
The expressions can be:
Current Green: If(CurrentMonthExpression>=0, CurrentMonthExpression, '')
Current Red: If(CurrentMonthExpression<0, CurrentMonthExpression, '')
Last Green: If(LastMonthExpression>=0, LastMonthExpression, '')
Last Red: If(LastMonthExpression<0, LastMonthExpression, '')
Thanks for replying.
But as per the expression you provided, how it will change the color of the expression result?
I think that changing the color dynamically is currently not available in Qlik Sense for text & image charts. You can use KPI object and go to Apperance > Color > Conditional color and set limits and colors.
Hi Anil, it will not change colors:
For each value you have a red and a green expression, if it's below 0, the red expression shows the value, the green expression has an empty string (so it's not visible). If the expression is above zero, the green expression shows the value and the red one has an empty string. It simulates than the expression is changing colors.