Discussion board where members can get started with Qlik Sense.
I want to apply colors on a range in pivot table, I have used 1 dimension and 1 measure. In measure I have applied a condition where I want to see only outstanding more than 3L and used the following expression
Now, I want background-color to each range i.e. 3l-5l: green 5l-8l:blue and 8L> red
but when i am appling the condition the values which are below 3l are also visible which i dont want.
I have used the following expression :
if(Outstanding>=300000 and Outstanding<=500000,Green(),
if( Outstanding>500000 and Outstanding<=800000,Blue(),
Please help me out with this.
On the dimension have you ticked the exclude null values?
yes, I have unchecked the show null values.
however when I not using the background- color at that time the values displayed are only above 3L
and when I am using the color condition at that time all the vles are displayed