topic Re: Display when Value is beyond limit in QlikView

Display when Value is beyond limit

kakani87 — Wed, 03 Jan 2018 08:11:09 GMT

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.

tresB — Wed, 03 Jan 2018 08:32:25 GMT

Could you share your sample qvw?

YoussefBelloum — Wed, 03 Jan 2018 08:44:10 GMT

Hi,

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

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

Anil_Babu_Samineni — Wed, 03 Jan 2018 08:47:58 GMT

What is the measure?

kakani87 — Wed, 03 Jan 2018 10:20:38 GMT

Hi Tresesco,

PFA.

tresB — Wed, 03 Jan 2018 10:26:32 GMT

Try:

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

kakani87 — Wed, 03 Jan 2018 10:32:01 GMT

Thank you Tresesco.