Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have Date_ID,Full_DT in Date dimension.I have Clm_recieve_Dt in T_DTL_Fct.
I have multiples dates in Date dimension(means 2005 to 2018).But, I want to get two complete full years 2013 and 2014 into qlikview in the format(Jan'13-Dec'13) as previous year and (Jan'14-Dec'14) as Current year.
Ex: Date_ID , Full_DT
20140101, 2014-01-01
20140102 20140102
.....
20180101 2018-01-01
Clm_recieve_Dt
20140101
20140102
..
How to inner join date dimension with Clm_recieve_Dt in T_DTL_Fct in the script??
I want to get two complete full years 2013 and 2014 into qlikview in the format(Jan'13-Dec'13) as previous year and (Jan'14-Dec'14) as Current year.
Try this:
EX:
LOAD * Inline [
Date_ID , Full_DT
20140101, 2014-01-01
20140102 20140102
.....
20180101 2018-01-01
];
inner join
Clm_recieve_Dt as Date_ID
20140101
20140102
and filter by date with a resident load
I have done the same thing.But,What do you mean filter by date??
Can you please more clear on filter by date.Any Example??