color coding based on totals

[venky77777]

how to write in pivot table if sum(sales) > total sales then green() else red(). I wrote in background color section as if(sum(sales)<sum(total sales),red(),green()) but not getting correct result

[pravinboniface]

@venky77777 What do you mean when you say that you are not getting correct results?

Maybe sum(sales) is equal to sum(total sales).  So if you are swapping < and > to test, you may be getting the same result.

[David_Friend]

@venky77777 when posting be sure to specify what Qlik software you are using (and the version) we have multiple products so be sure to specify QlikView, QlikSense, Qlik Cloud, or NPrinting thanks!

[venky77777]

yes i done, but the problem is getting color for totals and also getting all red or all green based <or>

[venky77777]

sure. thanks for reply

[JonnyPoole]

Something like this to highlight totals?

[SemBL83]

Hi,

Try DIMENSIONALITY(). There's a help article with an example that will tell you everything about this function. This will allow you to define a different color scheme on different levels.

Does this help you with your question?

Dimensionality - chart function | Qlik Sense on Windows Help

With kind regards,

Sem

[venky77777]

when i wrote in background color section if(dimensionality()=1, if(sum(sales)<sum(total sales),red(),green())), getting table as below but not getting green color

[venky77777]

thanks for reply, i applied but I'm not getting 2 colors

[JonnyPoole]

send a screenshot of the result as well as the expression you used