Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Colour Formatting with time dimention

Hello,

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

conditional formatting.png

Any thoughts about solving it?

Thanks in advance.

Qlikview Newbie

Tags (1)
1 Solution

Accepted Solutions
greeshma_k
Contributor III

Re: Colour Formatting with time dimention

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

7 Replies
greeshma_k
Contributor III

Re: Colour Formatting with time dimention

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

backgroundcolor.png

Not applicable

Re: Colour Formatting with time dimention

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

greeshma_k
Contributor III

Re: Colour Formatting with time dimention

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

Not applicable

Re: Colour Formatting with time dimention

source file per attached. Thanks.

greeshma_k
Contributor III

Re: Colour Formatting with time dimention

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

Not applicable

Re: Colour Formatting with time dimention

Great stuff Greeshma. Thank you for your help.

mohammadkhatimi
Valued Contributor

Re: Colour Formatting with time dimention

PFA

Community Browser