Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

swatimoku
New Contributor II

Color Scheme in pivot table

Hie,

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

(Sum({<Outstanding={'>=300000'}>}Outstanding)/100000)

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

if(Outstanding>800000 ,red(),Null())))

Please help me out with this.

Thank you

2 Replies
ogster1974
Honored Contributor II

Re: Color Scheme in pivot table

On the dimension have you ticked the exclude null values?

swatimoku
New Contributor II

Re: Color Scheme in pivot table

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

null.PNG

color.PNG