Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
You should try the following expression:
View solution in original post
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.
Thank you for your answer undergrinder
As sangram suggested, you can use colormix1 or colormix2 for gradient coloring. Eg: =ColorMix1(Count(distinct [columnA])/Count(columnB),white(),green())