KPI with automated Date

[kavieweg]

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?

[petter · Accepted solution]

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:

[kavieweg]

THANK YOU PETER!!!

[kavieweg]

Do you have the same also for weight?

e.g. g, kg, t, mega t?