Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying 1.5(90 minutes) as 1.30(1 hour 30 minutes)

Hello

I have two calculated fields that round a minutes field into both half hour and quarter hour slots. These are used in a grid chart.

e.g. 110 minutes would be rounded down to 1.5(1 and a 1/2 hours) and 1.75(1 and 3/4 hours) respectively.

I would like these actually displayed oin the axis as 1.30 and 1.45 as in 1 hour 30 minutes and 1 hour 45 minutes.

Can this be done?

1 Reply
Not applicable
Author