Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script error

I am receiving the Script Error below when running this code -

PeriodTable:   //creating a table containing all the dates

Load Distinct

Entity,

Date,

MonthYear as Period

resident Final_Table

AsOfPeriodTable: // Creating Current and Rolling 12 period type

Load

Entity,

Date,

Period as AsOfPeriod,
'Current'
as PeriodType,

Period as MonthYear

Resident PeriodTable;

Concatenate (AsOfPeriodTable)

LOAD

Entity,

Date,

Period as AsOfPeriod,
'Rolling 12'
as PeriodType,

date(AddMonths(Period,1-IterNo()),'MMM-YYYY') as MonthYear

Resident PeriodTable

While IterNo() <= 12;


Inner Join(AsOfPeriodTable)

LOAD Period as MonthYear

Resident PeriodTable;


DROP Table PeriodTable;

AsOfPeriodTable2:   // to get separate Month and Year

Load

Entity as Entity,

AsOfPeriod,

Date as DateF,

date(date#(Date,'DD-MMM-YYYY'),'YYYY-MM-DD') as DateF2,

Year2date(AsOfPeriod,0,1,$(varMaxDate))*-1 as CurYTDFlag,

if(AsOfPeriod<=AddMonths(MonthEnd($(varMaxDate)),-12),Year2Date(AsOfPeriod,-1,1,$(varMaxDate))*-1,0) as LastYTDFlag,

month(AsOfPeriod) as MonthAsOf,

year(AsOfPeriod) as YearAsOf,

PeriodType,

MonthYear

Resident AsOfPeriodTable;

DROP Table AsOfPeriodTable;

QlikView Error.jpg

Does any one know what this error is suggesting and how I get this to work?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

The error I was receiving was due to the fact that Entity, Date and MonthYear did not appear in all the data sets. Therefore the PeriodTable could not be created and this error occured.

View solution in original post

2 Replies
Gysbert_Wassenaar

try putting $(varMaxDate) in single quotes:

if(AsOfPeriod<=AddMonths(MonthEnd('$(varMaxDate)'),-12),Year2Date(AsOfPeriod,-1,1,$(varMaxDate))*-1,0) as LastYTDFlag,


talk is cheap, supply exceeds demand
Not applicable
Author

The error I was receiving was due to the fact that Entity, Date and MonthYear did not appear in all the data sets. Therefore the PeriodTable could not be created and this error occured.

View solution in original post