Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

Display when Value is beyond limit

Dear All,

When i'm trying to display total time spent in hrs with a specific colour as the above chart in the image shared when greater than 8 hrs.

can any one help me to acheive this.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try:

if(hour([Time Spent])>8,Yellow(),Green())

Capture.JPG

View solution in original post

6 Replies
tresesco
MVP
MVP

Could you share your sample qvw?

YoussefBelloum
Champion
Champion

Hi,

try to extract the hour from your TIME field and do this:

if( Hour([time spent] > 9, yellow(), green() )

Anil_Babu_Samineni

What is the measure?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
kakani87
Specialist
Specialist
Author

Hi Tresesco,

PFA.

tresesco
MVP
MVP

Try:

if(hour([Time Spent])>8,Yellow(),Green())

Capture.JPG

kakani87
Specialist
Specialist
Author

Thank you Tresesco.