Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vern2022
Contributor III
Contributor III

Colour by Row Dimension and Quartile

Hi all,

How do colour by the lower level dimension instead of all. (Background expression for measure)

Vern2022_0-1679504506886.png

At the moment. My syntax is this: if (Fractile([DeliveryVolume], 0.25) > 0.25, if(Fractile([DeliveryVolume], 0.75) < 0.75, green(), red()), red()). Its colour all three row dimensions, it is just the lower level one I want to colour.

Many thanks. 

Labels (6)
0 Replies