Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Add up down middle arrays in qliksense pivot table

Hello All ,

I have below pivot table in qliksense:-

Dimension - Quarter , Month , Type

Measure -=Sum({<Flag={'Actual'}>}value), =Sum({<Flag={'Budget'}>}value)

Aspiring_Developer_0-1729607746725.png

 

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

Aspiring_Developer_1-1729607850949.png

But I am unable to set the colour coding . Can anyone please help ?

@Kushal_Chawda   @tresesco 

Thanks

Labels (2)
4 Replies
Kushal_Chawda

@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
)
)
Aspiring_Developer
Specialist
Specialist
Author

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

Aspiring_Developer_0-1729617508080.png@Kushal_Chawda 

Qrishna
Master
Master

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:

Capture.PNG

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:

Capture2.PNG

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.

Kushal_Chawda

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