Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deepanshu_chamo1
New Contributor

Time format

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!!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Time format

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


talk is cheap, supply exceeds demand
3 Replies
Chanty4u
Esteemed Contributor III

Re: Time format

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())

deepanshu_chamo1
New Contributor

Re: Time format

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

MVP & Luminary
MVP & Luminary

Re: Time format

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


talk is cheap, supply exceeds demand