One solution might be:
Table1: LOAD [Field A], [Date Purchased], MonthName([Date Purchased]) as MonthPurchased, [Field B] FROM [https://community.qlik.com/thread/280447] (html, codepage is 1252, embedded labels, table is @1); Table2: LOAD [Field C], [Date ordered], MonthName([Date ordered],1) as MonthPurchased, [Field D] FROM [https://community.qlik.com/thread/280447] (html, codepage is 1252, embedded labels, table is @2);
hope this helps
QlikCommunity_Thread_280447.qvw 162.0 K
Marco Thanks again for your help.
As always, the requirements in reality are a lil complex :-)
addtional reqs are Table 1 & 2 has 3 common fields Country, Region and Taxable. so when joining Date purchased with Date Ordered (one month behind)- how to implement your logic while linking these 3 common fields. I have created the new tables below.
Field A Date Purchased Country Region Taxable 1 1/1/2017 USA A Y 2 1/2/2017 USA B N 3 1/3/2017 USA C N 4 2/1/2017 IND A Y 5 2/2/2017 RUS B N 6 2/3/2017 CHI B Y 7 2/4/2017 USA C Y
Field C Date Ordered Country Region Taxable 100 12/1/2016 USA A Y 200 12/2/2016 USA B N 300 12/3/2016 USA C N 400 1/1/2017 IND A Y 500 1/2/2017 RUS B N 600 1/3/2017 CHI B Y 700 1/4/2017 BRA C Y
Date Purchased-Monthstart Field A Field C Jan 2017 6 600 Feb 2017 22 1200
when summing these 3 new fields also should match. For eg, I included all rows from Table 2 except last row where Country is Brazil.