I'm new to Qlikview and I've been beating my head against this issue for the past week. I have two tables one of them a master calendar generated from a script. The other has implementation date and 20 columns of fiscal year total from FY2000-FY2020.
I build my two tables with the following and create the associate between the two tables by creating an alias of Date for Implementation Date and CalendarDate. When I push Ctrl + t I see the association between the two tables, but when I create my straight table with an expression to sum my fiscal periods there is no functionality with the calendar table (meaning when I select CalendarYear or CalendarMonthName the straight table isn't affected.... Why is this?:
Fact:
LOAD Director,
SSM,
Analyst,
[Category / Description],
Category,
[Contract Area],
Condition,
Division,
RHM,
[RHM Rollup],
[FY01 Savings],
[FY02 Savings],
[FY03 Savings],
[FY04 Savings],
[FY05 Savings],
[FY06 Savings],
[FY07 Savings],
[FY08 Savings],
[FY09 Savings],
[FY10 Savings],
[FY11 Savings],
[FY12 Savings],
[FY13 Savings],
[FY14 Savings],
[FY15 Savings],
[FY16 Savings],
[FY17 Savings],
[FY18 Savings],
[FY19 Savings],
[FY20 Savings],
[Implementation Date] AS Date,
[Validated Date],
[Months of Savings],
[Budget Category],
URL
FROM
(ooxml, embedded labels);
Calendar:
LOAD CalendarDate AS Date,
%DATE_KEY,
CalendarDayOfMonth,
CalendarDayName,
CalendarWeekOfYear,
CalendarMonthName,
CalendarQuarter,
CalendarYear,
CalendarWeekNumberAndYear,
CalendarMonthAndYear,
CalendarQuarterMonthsAndYear,
CalendarDayStart,
CalendarWeekStart,
CalendarMonthStart,
CalendarQuarterStart,
CalendarYearStart,
CalendarDayEnd,
CalendarWeekEnd,
CalendarMonthEnd,
CalendarQuarterEnd,
CalendarYearEnd,
CalendarQuarterAndYear,
CalendarYearAndQuarter,
CalendarWednesdays,
FiscalMonthNum,
FiscalYearDesc,
%Fiscal_Key,
FYRPR,
FiscalYear,
FiscalYearQuarter
FROM
(qvd);
