Hi,
I have one qlikview file. The source file using in this qlikview file is Excel. and it is scheduled on weekly basis. I have calendar like below with varibales. But I can't able to see the variables as when I opened Variable Overview tab it is showing blank. Could anyone help me why it is getting like that. And because of this i am getting errors in expressions. please help
SortMap:
MAPPING LOAD * INLINE [
Month, MonthSort
Jul, 1
Aug, 2
Sep, 3
Oct, 4
Nov, 5
Dec, 6
Jan, 7
Feb, 8
Mar, 9
Apr, 10
May, 11
Jun, 12
];
Calendar:
LOAD Date as [Date Reviewed],
Date_TS,
Today,
Week,
Year,
Text(Month) as Month,
ApplyMap('SortMap',Text(Month)) as MonthSort,
Day,
WeekDay,
Quarter,
MonthYear,
WeekYear,
CurYTDFlag,
LastYTDFlag,
FiscalYear,
FiscalYearStart,
FiscalWeek,
FiscalWeekSerial,
FiscalQuarter
FROM
[..\Extractor\QVD_Annuals\MasterCalendar.qvd]
(qvd);
CurrentFinancialWeek:
LOAD Year,Week,FiscalWeek,FiscalWeekSerial,FiscalYear,FiscalYearStart RESIDENT Calendar WHERE Week=(Week(Today())) and Year=Year(Today())
Order BY Year ASC;
LET curFiscalWeek=
Peek('FiscalWeek',0,
CurrentFinancialWeek);
LET
curFiscalYear=
Peek('FiscalYear',0,
CurrentFinancialWeek);
LET
curWeek=
Peek('Week',0,
CurrentFinancialWeek);
LET
curYear=
Peek('Year',0,
CurrentFinancialWeek);
LET
curFiscalWeekSeq=
Peek('FiscalWeekSerial',0,
CurrentFinancialWeek);
LET
curFiscalYearStart=
Peek('FiscalYearStart',0,
CurrentFinancialWeek);
DROP
TABLE CurrentFinancialWeek;
