Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All ,
I have below pivot table in qliksense:-
Dimension - Quarter , Month , Type
Measure -=Sum({<Flag={'Actual'}>}value), =Sum({<Flag={'Budget'}>}value)
I want to apply below condition on Actuals column and I wish to add the indicator in the actual column with number :-
Condition -IF Actual < 90% of Budget then green
IF Actual >=90% of Budget <100% of Budget the Amber
If Actual >=100% of Budget the Red
I created below expression :-
=Sum({<Flag={'Actual'}>}value) & chr(10) & If(
Sum({<Flag={'Actual'}>} value) < 0.9 * Sum({<Flag={'Budget'}>} value),
chr(9660), // Down Arrow
If(
Sum({<Flag={'Actual'}>} value) >= 0.9 * Sum({<Flag={'Budget'}>} value) and
Sum({<Flag={'Actual'}>} value) < 1 * Sum({<Flag={'Budget'}>} value),
chr(9654), // Right Arrow
chr(9650) // Up Arrow
)
)
But I am unable to set the colour coding . Can anyone please help ?
Thanks
@Aspiring_Developer what did you get if you add below expression in background colour expression for Actual measure
=If(
Sum({<Flag={'Actual'}>} value) < 0.9 * Sum({<Flag={'Budget'}>} value),
red(), // red color
If(
Sum({<Flag={'Actual'}>} value) >= 0.9 * Sum({<Flag={'Budget'}>} value) and
Sum({<Flag={'Actual'}>} value) < 1 * Sum({<Flag={'Budget'}>} value),
green(), // Green color
red() // red color
)
)
I just want to colour the arrows not the entire cell :-
Same cell different colors for different pieces of text i think it is not possible in a tabular cell by default. All you can do is something like below with qlik expressions:
You could create two columns, one with value, one with Arrows and kind of merge the columns by playing with cell boundary colors that gives the user the illusion of same cell like below:
or you could try HTMl/css formatting using something like :
'<span style="color:red;">Red Text</span> Normal Text <span style="color:blue;">Blue Text</span>'.
I remember there used to be an extension thats prebuilt with this functionality but i dont see it anywhere now. may be someone can come up with a Qlik Expression/Extension solution soon.
@Aspiring_Developer If you just want to colour arrows, you need to create separate expression just for arrow and use suggested expression for text colour expression of that measure, because it's not possible to change the colour for individual characters.