Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Hr to Days in UI

Hi all,

I want to convert the  hrs into days in front end  ?

how can I achieve this?

cloumnName: 

Time(in hrs)

36

45

65

 

like that  how can I achieve?

Thanks

Sonica

1 Solution

Accepted Solutions
sunny_talwar

May be this

Interval(Interval#(Time, 'hh'), 'D hh')

View solution in original post

11 Replies
sunny_talwar

May be this

Interval(Interval#(Time, 'hh'), 'D hh')

soniasweety
Master
Master
Author

hr.PNGbut for negative values it showing like below

sunny_talwar

You have negative values in Time? What would you want to see for the negative time?

JustinDallas
Specialist III
Specialist III

Then use FABS to get a positive value.

Fabs(Interval(Interval#(Time, 'hh'), 'D hh'))

soniasweety
Master
Master
Author

same  -

-3

-2

-5 like that

soniasweety
Master
Master
Author

no I want to show negative only

sunny_talwar

May be this

Dual(Sign(Time) & Interval(Interval#(Time, 'hh'), 'D hh'), Time)

soniasweety
Master
Master
Author

the result is not comingdays.PNG

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

The problem is when you export to excel.

 

-56#############################################
-24#############################################
-12#############################################
-5#############################################
-3#############################################
-2#############################################
3636:00:00
4545:00:00
6565:00:00

When copy/past Full table it's ok (on QlikView):

timeInterval(Interval#(time, 'hh'), 'D hh')
-56-2 08
-24-1 00
-12-0 12
-5-0 05
-3-0 03
-2-0 02
361 12
451 21
652 17
Help users find answers! Don't forget to mark a solution that worked for you!