Discussion board where members can get started with Qlik Sense.
I want to convert the hrs into days in front end ?
how can I achieve this?
like that how can I achieve?
Go to Solution.
May be this
Interval(Interval#(Time, 'hh'), 'D hh')
but for negative values it showing like below
You have negative values in Time? What would you want to see for the negative time?
Then use FABS to get a positive value.
Fabs(Interval(Interval#(Time, 'hh'), 'D hh'))
-5 like that
no I want to show negative only
Dual(Sign(Time) & Interval(Interval#(Time, 'hh'), 'D hh'), Time)
the result is not coming
The problem is when you export to excel.
When copy/past Full table it's ok (on QlikView):