topic Re: Colour Formatting with time dimention in QlikView

Colour Formatting with time dimention

Thu, 14 May 2015 04:24:03 GMT

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 — Thu, 14 May 2015 05:11:59 GMT

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()))

Thu, 14 May 2015 06:19:34 GMT

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

Anonymous — Thu, 14 May 2015 06:30:53 GMT

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

Thu, 14 May 2015 06:33:12 GMT

source file per attached. Thanks.

Anonymous — Thu, 14 May 2015 07:18:09 GMT

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

Thu, 14 May 2015 07:38:36 GMT

Great stuff Greeshma. Thank you for your help.

mohammadkhatimi — Thu, 14 May 2015 07:49:57 GMT

PFA