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?:
If it's not really a true QlikView date field what are my options to join the two date fields? There are several variances in the formatting of the date and some don't have a date they'll have character strings in it such as varries, varry, ect...
My Date field in the calendar table is formatted as the following: 36526 for 1/1/2000, 36527 for 1/2/2000. The Date in the Fact table is formatted as 1/1/2000 or 1/01/2000, or 01/01/2000.