Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

  

TimeStampBW % Level
4/20/16 12:00 AM90%
4/20/16 12:10 AM10%
4/20/16 12:20 AM10%
4/20/16 12:30 AM10%
4/20/16 12:40 AM10%
4/20/16 12:50 AM10%
4/20/16 1:00 AM10%
4/20/16 1:10 AM80%
4/20/16 1:20 AM85%
4/20/16 1:30 AM92%
4/20/16 1:40 AM90%
4/20/16 1:50 AM10%
4/20/16 2:00 AM10%
4/20/16 2:10 AM10%
4/20/16 2:20 AM10%
4/20/16 2:30 AM10%
4/20/16 2:40 AM10%
4/20/16 2:50 AM90%
4/20/16 3:00 AM10%
4/21/16 12:00 AM10%
4/21/16 12:10 AM10%
4/21/16 12:20 AM10%
4/21/16 12:30 AM10%
4/21/16 12:40 AM10%
4/21/16 12:50 AM90%
4/21/16 1:00 AM10%
4/21/16 1:10 AM10%
4/21/16 1:20 AM10%
4/21/16 1:30 AM10%
4/21/16 1:40 AM10%
4/21/16 1:50 AM10%
4/21/16 2:00 AM90%
4/21/16 2:10 AM10%
4/21/16 2:20 AM10%
4/21/16 2:30 AM10%
4/21/16 2:40 AM10%
4/21/16 2:50 AM10%
4/21/16 3:00 AM10%
15 Replies
ThornOfCrowns
Specialist II
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()
))

Conditional_above.PNG

Anonymous
Not applicable
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

Anonymous
Not applicable
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

Anonymous
Not applicable
Author

ThornOfCrowns
Specialist II
Specialist II

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

Anonymous
Not applicable
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>