Search code examples
qliksensesense

Colour by Row Dimension and Quartile Qlik Sense

Pivot Table As is Now

Hi all,

In Qlik Sense. How do I colour by the lower level dimension instead of all. (Background expression for measure). Stack will only let me attach the image as a link. Sorry about that.

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

Many thanks.

Solution

  • Try using the Dimensionality() function:

    =if( Dimensionality() = 3
, if (Fractile([DeliveryVolume], 0.25) > 0.25, if(Fractile([DeliveryVolume], 0.75) < 0.75, green(), red()), red())
)