topic Re: Add up down middle arrays in qliksense pivot table in App Development

Add up down middle arrays in qliksense pivot table

Aspiring_Developer — Tue, 22 Oct 2024 14:39:16 GMT

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 ?

@Kushal_Chawda @tresB

Thanks

Re: Add up down middle arrays in qliksense pivot table

Kushal_Chawda — Tue, 22 Oct 2024 14:52:11 GMT

@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 ) )

Re: Add up down middle arrays in qliksense pivot table

Aspiring_Developer — Tue, 22 Oct 2024 17:19:16 GMT

I just want to colour the arrows not the entire cell :-

@Kushal_Chawda

Re: Add up down middle arrays in qliksense pivot table

Qrishna — Tue, 22 Oct 2024 20:40:00 GMT

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.

Re: Add up down middle arrays in qliksense pivot table

Kushal_Chawda — Wed, 23 Oct 2024 10:51:54 GMT

@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.