topic Re: Time format in App Development

Time format

Anonymous — Wed, 21 Sep 2016 03:45:05 GMT

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 — Wed, 21 Sep 2016 04:35:23 GMT

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 — Wed, 21 Sep 2016 06:45:40 GMT

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 — Wed, 21 Sep 2016 06:54:34 GMT

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