Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
kvijay173
Creator
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.

  

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

kvijay173
Creator
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

kvijay173
Creator
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

kvijay173
Creator
Creator
Author

ThornOfCrowns
Specialist II
Specialist II

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

kvijay173
Creator
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>