Problem with calendar

qlikconsultant — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have the following Code:

Sales
LOAD i_ticket,
     date(d_date,'DD.MM.YYYY') as d_date,
     Sale
  FROM

(qvd);


Concatenate
Bonus:
LOAD i_ticket,
     date(d_date,'DD.MM.YYYY') as d_date,
     Bonus
FROM

(qvd);

and a calendar:

//-----------------------------------------------------------------------------------------------------------------------------
LET vMinBetDate = num('01.01.2016');
LET vMaxBetDate = today()-1;


TempCalendar_Betday: 
LOAD 
               $(vMinBetDate) + Iterno()-1                     as TempNum,
               Date($(vMinBetDate) + IterNo() - 1)             as TempDate 
               AutoGenerate 1 While $(vMinBetDate) + IterNo()-1 <= $(vMaxBetDate);

         
Calendar_Betday: 
Load 
               date(TempDate,'DD.MM.YYYY')                            as d_date,
               weekday(TempDate)                                    as Weekday, 
               week(TempDate)                                         as Week, 
               Year(TempDate)                                          as Year, 
               Month(TempDate)                                       as Month, 
               weekyear(TempDate)*100+week(TempDate)                 as YearCW,
               year(TempDate)*100+month(TempDate)                     as YearMn,
               num(month(TempDate))                                 as MonthNr
                  
Resident TempCalendar_Betday
Order By TempDate ASC; 
      
drop table TempCalendar_Betday;

////-----------------------------------------------------------------------------------------------------------------------------

My problem is if i select a Month or MonthNr I get only i get only data from table Sales.

Re: Problem with calendar

Gysbert_Wassenaar — Mon, 25 Jul 2016 12:19:48 GMT

Perhaps Bonus doesn't contain any dates from 2016. Or perhaps the values in its d_date field are not dates but text values.

Re: Problem with calendar

Clever_Anjos — Mon, 25 Jul 2016 12:27:42 GMT

Please run only this piece of code and inspect the values of d_date

Bonus:
LOAD i_ticket,
date(d_date,'DD.MM.YYYY') as d_date,
Bonus
FROM
(qvd);

Re: Problem with calendar

qlikconsultant — Mon, 25 Jul 2016 13:13:58 GMT

d_date was a timestamp.

Thanks for the help.

Re: Problem with calendar

Clever_Anjos — Mon, 25 Jul 2016 13:17:19 GMT

Use this instead

Bonus:
LOAD i_ticket,
date(floor(d_date),'DD.MM.YYYY') as d_date,
Bonus
FROM
(qvd);

Correct Answer • Reply

topic Re: Problem with calendar in QlikView

Problem with calendar

Re: Problem with calendar

Re: Problem with calendar

Re: Problem with calendar

Re: Problem with calendar