Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Hi Amelia,
Your Calandar QVD does not seem to have data for today. Hence it will fail. As per your logic these variables will be populated only when there is value for today. Your CurrentFinancialWeek table will be vlank in this case too.
thanks,
Rajesh Vaswani