Set Conditional Formatting of cell Based on a Separate Measure

[tsaho8]

Hi @Angelina_QBeeQ ,

I want to set color(red & green) of Rank cell based on Overall Vol measure.

if Overall Vol>2000 then Rank cell will be Red else Green.

Logic of Overall Vol is Count(call)

[Benji_PaldiTeam]

Hi @tsaho8 ,

Take a look at this post, it will probably help you with your use case.
IIf you need any further assistance or advanced capabilities over your pivot feel free to reach out,
we're always happy to help (: 

[email protected]

Paldi Solutions - Number #1 Sisense Plugins Developer 

[tsaho8]

Hi @Benji_PaldiTeam ,

This post won't help me because we need to provide the condition with another measure like below.

if Overall Vol>2000 then Rank cell will be Red else Green

[Ido_QBeeQ · Accepted solution]

Hey @tsaho8 it's great to see you're tagging @Angelina_QBeeQ and  the QBeeQ team, keep it up! We're very happy to help the Sisense community!

To do this you need to take the Rank function into consideration into the conditional formatting calculation of the Overall vol, and move it to the other side of the equation. You need to color Y according to X, if X is above or 2000:

What you need - X>2000

What you have is Y static on the left hand side of the equation, so you need to multiply by Y and divide by X:

Y>(Y/X)*2000 => Y/Y>(Y/X)*2000/Y => 1>2000/X => X>2000

See screenshot and attached dash file

Always here to help 🙂

Ido 

[email protected]

QBeeQ - Gold Implementation & Development Partner

[tsaho8]

Hi @Ido_QBeeQ ,

You have written formula in the condition section(referring image) but how it will compare.

In my case Overall Vol logic I can put but how will compare with 2000?

Could you please make it more simpler.

[zohebakber]

Hi Ido,
I am very close. However, this work around fails when value of X=0

[Ido_QBeeQ]

@tsaho8 Your formula should look like this:

2000*[Overall Vol]/[Rank]