Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
greeshma_k
Creator III
Creator III

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

View solution in original post

7 Replies
greeshma_k
Creator III
Creator III

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
Author

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

greeshma_k
Creator III
Creator III

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
Author

source file per attached. Thanks.

greeshma_k
Creator III
Creator III

Hi,

Please see attached.

Edit: Have changed sorting and background color for 0 values

Regards,

Greeshma

View solution in original post

Not applicable
Author

Great stuff Greeshma. Thank you for your help.

mohammadkhatimi
Partner
Partner

PFA