I have Date Dimension like below for multiple years.But, I don't want all years into qlikview.
How to create a flag and pull the date for Jan'13-Dec'13 as current year and Jan'14-Dec'14 as previous year??
Date_key_ID, FullDT
20120101 (YYYY-MM-DD) 2012-01-01
20120102,
20120103,
...
20121230
20121231..
How to inner Join dates in Date dimension with Clm_recieve_DT in T_FCT table??
Clm_recieve_DT
20120101,
20120102,
20120103,
...