topic Problem with hours in calendar in QlikView

Problem with hours in calendar

Fri, 05 Dec 2014 12:23:11 GMT

Hello,

I have the following problem. I have a test table in excel where are 3 columns. The first one is the date in format 'd.m.rrrr hh', the second is the amount of sth and the last one is the same as the first but in number format.

As next I have a calendar (the smallest value is the hour) generate this way:

TempCalendar:

LOAD

$(varMinDate) + (IterNo()/24) As Num

AutoGenerate 1 While $(varMinDate) + (IterNo()/24) < $(varMaxDate);

The calendar seems to be OK. But I have a straight table by hours and only one value is different from the source. The value for the hour 13 is summarized into 12h. But WHY? I used this key between source and calendar to Date(floor(Num,1/24),'d.M.YYYY hh') as DateHours.

Is this because of the wrong way with generation calendar by hours of is the floor function inappropriate?

Thanks in advance,

Regards,

Peter

Re: Problem with hours in calendar

Anonymous — Fri, 05 Dec 2014 12:30:22 GMT

Hi Petr,

Please refer to below link:

Master calendar with hour

Regards

Neetha

Re: Problem with hours in calendar

Anonymous — Fri, 05 Dec 2014 13:15:11 GMT

Maybe related to formatting issues.

Try using numbers as key instead of "date + hour".

Serhan

Re: Problem with hours in calendar

giakoum — Fri, 05 Dec 2014 13:18:47 GMT

put your data in a excel so that we can try this as well