Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Master Time Calendar

Hi

I'm trying to create a master time calendar with numeric values (So I can use continous axis)

But when I use the floor function, some minutes are grouped as one.

i.e. the minute 00:08 disapears and the minute 00:07 has two values.

But if I load the minutes as text, all minutes are displayed (but as text, and not as numbers)

What am I doing wrong?

I have uploaded an example of this!

This is the code i'm using to load the minutes:

LOAD Time(Floor(Frac(A),1/1440),'hh:mm')  as [HH:mm],

  Text(B)  as [HH:mm_txt]

FROM

[Test_HoraMinuto.xlsx]

(ooxml, no labels, table is Hoja1);

3 Replies
cristian_av
Creator III
Creator III
Author

I'm using floor because in the original data i also have seconds! (and I dont need seconds)

Anonymous
Not applicable

Hi,

Try:

Time#(A,'hh:mm') as [HH:mm]

Regards

Neetha

sunny_talwar

Try this:

If(RowNo() = 1, Time(Floor(Frac(A),1/1439),'hh:mm:ss'), Time(Floor(Frac(A),1/1439) + 0.00069444444444444,'hh:mm:ss'))  as [HH:mm]