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
hour(field) as hour
Second(field) as second in script
if front end
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
if( SUM(A)/SUM(B) < 10, Green(), if( SUM(A)/SUM(B) < 50, Yellow(), Red()))
Retrieving data ...