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: 
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
sunny_talwar

Is this how the raw data comes for you? in percentage form?

Chanty4u
MVP
MVP

try this

BW Level % as

YELLOW if it is above 75%

GREEN if below 75%

RED if above 75%

=if([ BW Level %]>75%, yellow(), if([ BW Level %]<=75%, Green() ,Red())

kkkumar82
Specialist III
Specialist III

I think the red color is tricky here chanty, it may not be always correct if all the two conditions are not met

kkkumar82
Specialist III
Specialist III

Hi Vijay ,

Can you high the rows which must be in red in your above data

kvijay173
Creator
Creator
Author

Yes this is how I get the raw data..

Trick we could say if it is above or below 75% but We have to see if it is above 75% and continuously sustaining for more than 10 minutes then I have to say it as RED

kkkumar82
Specialist III
Specialist III

In your data you posted do you have any of the rows which have %>75 and last long for more than 10 minutes

ThornOfCrowns
Specialist II
Specialist II

You will probably need to look at the last row of data to see if that breaches the %age then use that as an AND in your conditional formatting expression.

kvijay173
Creator
Creator
Author

See the entries below pls

  

4/20/16 1:10 AM80%
4/20/16 1:20 AM85%
4/20/16 1:30 AM92%
4/20/16 1:40 AM90%
kvijay173
Creator
Creator
Author

4/20/16 1:10 AM80%
4/20/16 1:20 AM85%
4/20/16 1:30 AM92%
4/20/16 1:40 AM90%