Create Flag on dates and join on tables

[#1]

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.

[ecolomer]

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

[#3]

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??