topic Create Flag on dates and join on tables in QlikView

Create Flag on dates and join on tables

Tue, 27 Oct 2015 17:05:31 GMT

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.

Re: Create Flag on dates and join on tables

ecolomer — Tue, 27 Oct 2015 19:14:02 GMT

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

Re: Create Flag on dates and join on tables

Thu, 29 Oct 2015 01:25:21 GMT

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