# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Creator

## How can we do conditional coloring based on the % column?

I have 2 columns as shown below (also have attached a sample excel)

I would like to do a conditional coloring but ... here comes the challenge

The first column is the TIMESTAMP which is a record poll of every 10 minutes.

I want to to show the BW Level % as

YELLOW if it is above 75%

GREEN if below 75%

RED if above 75% but sustaining for more than 10 minutes continuously.

We can create a formula to say whether it is above 75% or not but I dont know how to analyze if BW level was sustaining continuously for more than 10 minutes.

Really dont know how to do this and need you help please.

 TimeStamp BW % Level 4/20/16 12:00 AM 90% 4/20/16 12:10 AM 10% 4/20/16 12:20 AM 10% 4/20/16 12:30 AM 10% 4/20/16 12:40 AM 10% 4/20/16 12:50 AM 10% 4/20/16 1:00 AM 10% 4/20/16 1:10 AM 80% 4/20/16 1:20 AM 85% 4/20/16 1:30 AM 92% 4/20/16 1:40 AM 90% 4/20/16 1:50 AM 10% 4/20/16 2:00 AM 10% 4/20/16 2:10 AM 10% 4/20/16 2:20 AM 10% 4/20/16 2:30 AM 10% 4/20/16 2:40 AM 10% 4/20/16 2:50 AM 90% 4/20/16 3:00 AM 10% 4/21/16 12:00 AM 10% 4/21/16 12:10 AM 10% 4/21/16 12:20 AM 10% 4/21/16 12:30 AM 10% 4/21/16 12:40 AM 10% 4/21/16 12:50 AM 90% 4/21/16 1:00 AM 10% 4/21/16 1:10 AM 10% 4/21/16 1:20 AM 10% 4/21/16 1:30 AM 10% 4/21/16 1:40 AM 10% 4/21/16 1:50 AM 10% 4/21/16 2:00 AM 90% 4/21/16 2:10 AM 10% 4/21/16 2:20 AM 10% 4/21/16 2:30 AM 10% 4/21/16 2:40 AM 10% 4/21/16 2:50 AM 10% 4/21/16 3:00 AM 10%
15 Replies
Specialist II

Try this in your background colour  expression:

if([BW % Level]>0.75 and above([BW % Level],1)>0.75 ,Red(),

if([BW % Level]>0.75,Yellow()

,
Green()
))

Creator
Author

@ James I am looking a final sumarry result as 20-APR-2016 with a RED color since we have >75% continously occured on this particular day

Creator
Author

apologies If I am not clear for 20th APR we have entries and since had >75% entried continousuly without breakup the 20th Apr final summary should be red. If not continous entries for >75% then final summary should be YELLOW if not entries for 75% at all then green

Creator
Author

Specialist II

That's a totally different question to the one you posted originally.

Creator
Author

Yes but that was my actual requirement. Need your help on this

On Wed, Apr 20, 2016 at 7:05 PM, James Summerson <qcwebmaster@qlikview.com>

Community Browser