Colour Formatting with time dimention

[#1]

Hello,

I would like to create conditional formatting in Qlikview where the rules is similar to MS Excel conditional formatting as follow.

Any thoughts about solving it?

Thanks in advance.

Qlikview Newbie

[Anonymous]

Hi,

Go to your expression and click on the '+' symbol. You can add an expression here as follows

if( sum({<Date={'$(=max(Date))'}>}Price) > sum({<Date={'$(=max(Date)-1)'}>}Price), red(),

   if( sum({<Date={'$(=max(Date))'}>}Price) < sum({<Date={'$(=max(Date)-1)'}>}Price), green(),yellow()))

[#3]

Not able to get the desire output. Attached QV file.

[Anonymous]

Hi,

The dates are not continuous so max(Date)-1 will not work here. I am working on your QVW. Can you also send the source file?

Regards,

Greeshma

[#5]

source file per attached. Thanks.

[Anonymous · Accepted solution]

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

[#7]

Great stuff Greeshma. Thank you for your help.

[mohammadkhatimi]

PFA