topic Qlik sense background color expression - Conditional Formatting in App Development

Qlik sense background color expression - Conditional Formatting

fatihtomruk — Thu, 14 Jan 2016 07:38:54 GMT

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.

Re: Qlik sense background color expression - Conditional Formatting

undergrinder — Fri, 15 Jan 2016 09:00:07 GMT

Hi Fatih,

You should try the following expression:

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

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

HTH

Re: Qlik sense background color expression - Conditional Formatting

reddy-s — Fri, 15 Jan 2016 21:01:55 GMT

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.

Re: Qlik sense background color expression - Conditional Formatting

fatihtomruk — Thu, 04 Feb 2016 07:37:08 GMT

Thank you for your answer undergrinder‌

Re: Qlik sense background color expression - Conditional Formatting

tejes — Mon, 15 Jul 2019 13:05:33 GMT

Hi,

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