Problems with Master Calendar

Anonymous — Thu, 05 Jul 2018 07:48:56 GMT

Hi,

I use a Master Calender with 2-hours-intervals. This works fine, but I have a problem, that I can´t solve.

I load the minDate and set the minDate to the Variable varMinDate, but the problem is, the varMinDate is not long enough and gets another value than the minDate is. For example when the minDate is ...,5, there is no problem, but if the minDate is something like

43.270,33333333333600 the varMinDate will be 43270.333333333 :-(. Can anyone help me to get more Information into the variable?

The effect is, that I have a lot of double Intervals

Thanks a lot

Agathe

This is my Code:

Set DecimalSep='.';
MaxMinDate:
load
min(INTERVAL_START) as MinDate,
max(INTERVAL_START) as MaxDate
resident Key;

let varMinDate = Num(peek('MinDate',0,MaxMinDate));//,',','.','#.##0,00');
let varMaxDate = Num(peek('MaxDate',0,MaxMinDate));//,',','.','#.##0,00000000000000');

LET vDays = Num(varMaxDate - varMinDate) ;

drop table MaxMinDate;

Temp_Calendar:
Load
RowNo() as RowNo,
$(varMinDate) + RowNo()/12 AS DateNumber,
TimeStamp(Num($(varMinDate) + RowNo()/12)) AS TempDate
AUTOGENERATE 12* $(vDays);
Set DecimalSep=',';

Calendar:
LOAD TempDate AS INTERVAL_START,
date(TempDate) as Datum,
week(TempDate) As Woche,
Year(TempDate) As Jahr,
Month(TempDate) As Monat,
Day(TempDate) As Tag,
Hour(TempDate) AS Stunde
RESIDENT Temp_Calendar ORDER BY TempDate ASC;

DROP TABLE Temp_Calendar;

topic Problems with Master Calendar in QlikView

Problems with Master Calendar