Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

fatihtomruk
New Contributor III

Qlik sense background color expression - Conditional Formatting

Hi,

How can I make a conditional formatting in a Pivot Table?

I mean, I want to make background RED If the value is less than 0.

What formula should I write the background color expression?

Please find attached.

Thanks in advance.Capture.PNG

Tags (1)
1 Solution

Accepted Solutions
undergrinder
Valued Contributor II

Re: Qlik sense background color expression - Conditional Formatting

Hi Fatih,

You should try the following expression:

=if(Artis>0.5,red(),blue())

or

=if(Artis>0.5,rgb(123,12,125),rgb(255,255,255)

HTH

G.

View solution in original post

4 Replies
undergrinder
Valued Contributor II

Re: Qlik sense background color expression - Conditional Formatting

Hi Fatih,

You should try the following expression:

=if(Artis>0.5,red(),blue())

or

=if(Artis>0.5,rgb(123,12,125),rgb(255,255,255)

HTH

G.

View solution in original post

reddys310
Honored Contributor II

Re: Qlik sense background color expression - Conditional Formatting

Hi Fatih,

You can use the expression which under grinder provided an will work perfectly. If you have any complex colour expressions you can even make use of ColorMix() function to achieve it.

Thanks,

Sangram Reddy.

fatihtomruk
New Contributor III

Re: Qlik sense background color expression - Conditional Formatting

Thank you for your answer undergrinder

tejes
New Contributor III

Re: Qlik sense background color expression - Conditional Formatting

Hi,

As sangram suggested, you can use colormix1 or colormix2 for gradient coloring. Eg: =ColorMix1(Count(distinct [columnA])/Count(columnB),white(),green())