topic Re: Master calender error? in QlikView

Master calender error?

Fri, 31 Oct 2014 12:15:22 GMT

Hi,

kindly find below Attachment....

Master Calender, variablesare not working

Regards,

Re: Master calender error?

Gysbert_Wassenaar — Fri, 31 Oct 2014 12:23:27 GMT

Let varMaxDate = Num(Peek('OrderDate',-1,'t1’));

The last quote character is a not a single quote, but another quote character. Replace it by a real single quote.

Re: Master calender error?

rustyfishbones — Fri, 31 Oct 2014 12:41:10 GMT

You have this in the Script

you should have below, so you need to change the last quote to single quote

Re: Master calender error?

its_anandrjs — Fri, 31 Oct 2014 12:44:23 GMT

Try this load script and your Min and Max variable calculate wrong may be due to the wrong order in the table in peek function by -1 you get min value which opposite to the order or my be change in the variable i change it right now check the load script.

t1:

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity

FROM

Sales.xls

(biff, embedded labels, table is Orders$);

LET varMaxDate = Num(Peek('OrderDate', 0, 't1'));

LET varMinDate = NUM(Peek('OrderDate', -1, 't1'));

TempCalendar:

LOAD

$(varMinDate) + RowNo() - 1 AS DateNumber,

Date($(varMinDate) + RowNo() - 1) AS TempDate

AUTOGENERATE 1

WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

MasterCalendar:

Load

TempDate As OrderDate,

Week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month

resident TempCalendar;

Note:- Copy and paste this load script and variable script also.

Regards

Anand

Re: Master calender error?

MK_QSL — Fri, 31 Oct 2014 12:50:28 GMT

t1:

LOAD OrderID,

ProductID,

Product,

CustomerID,

EmployeeID,

OrderDate,

Margin,

Sales,

Cost,

Quantity

FROM

Sales.xls

(biff, embedded labels, table is Orders$);

MinMaxDate:

Load Min(OrderDate) as MinDate, Max(OrderDate) as MaxDate Resident t1;

Let varMinDate =Num(Peek('MinDate',0,'MinMaxDate'));

Let varMaxDate = Num(Peek('MaxDate',-1,'MinMaxDate'));

Drop Table MinMaxDate;

TempCalendar:

Load

$(varMinDate) + IterNo() - 1 as TempDate

Autogenerate 1

While $(varMinDate) + IterNo() - 1 <= $(varMaxDate);

MasterCalendar:

Load

TempDate As OrderDate,

Week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month

Resident TempCalendar;

Drop Table TempCalendar;