Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
i want a KPI with a duration formated automatically
If it is under 24 hours (only Minutes)
if it is over 24 hours something like this:
21 days 5 hours and 20 minutes
How can i do it in Qlik Sense Despktop?
Something like this in the KPI:
Expression:
If(d<1,Floor(d*24*60)&' minutes',Floor(d)&' days '&Replace(TimeStamp(Frac(d),'h:m'),':',' hours ')&' mins')
Label:
=If(d<1,'Total waiting time in minutes','Total waiting time')
For less than 24 hours:
For a day and upwards:
Something like this in the KPI:
Expression:
If(d<1,Floor(d*24*60)&' minutes',Floor(d)&' days '&Replace(TimeStamp(Frac(d),'h:m'),':',' hours ')&' mins')
Label:
=If(d<1,'Total waiting time in minutes','Total waiting time')
For less than 24 hours:
For a day and upwards:
THANK YOU PETER!!!
Do you have the same also for weight?
e.g. g, kg, t, mega t?