topic Re: Master Time Calendar in QlikView

Master Time Calendar

cristian_av — Thu, 05 Feb 2015 12:43:29 GMT

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);

cristian_av — Thu, 05 Feb 2015 13:09:04 GMT

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

Anonymous — Thu, 05 Feb 2015 14:00:04 GMT

Hi,

Try:

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

Regards

Neetha

sunny_talwar — Thu, 05 Feb 2015 14:44:09 GMT

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]