Time format

[Anonymous]

Hello All

I am working in Qlik Sense.. I have a query related to conditional formatting

I have the KPI in time format like 00:02:56 (hh:mm:ss)

I want to show if it is less than 10 sec than green, 10 - 50 sec yellow and Greater than 50 red.

Can you all please guide me

Thanks!!

[Chanty4u]

Hi,

Try below

Create

hour(field) as hour

Second(field) as second   in script

if front end

=if(second<10,Green(),if(second<50 ,yellow(),red())

[Anonymous]

Hello sir.. Thanks for your reply.

I have calculated the time in the front end for the KPI and then use Duration format

Like as (SUM(A)/SUM(B))/86400 ...

Now I want to color code it by using the above logic..

Please guide and let me know if it is making sense or not

Thanks

[Gysbert_Wassenaar · Accepted solution]

if( SUM(A)/SUM(B) < 10, Green(), if( SUM(A)/SUM(B) < 50, Yellow(), Red()))