How to associate 2 tables with diff dates

Anonymous — Wed, 08 Nov 2017 05:51:34 GMT

I have tried to ask the question before here https://community.qlik.com/thread/280447 but it was probably due to my poor sample data, failed to describe clearly. This time around I have tried my best. as seen below I have 2 tables that have 3 common fields: Country, Region & Payment Group. In the app attached, I have tried to fix that problem with a link table. My main req is to associate [Date Purchased] with[ Date Ordered] so that [Date ordered] is 1 month behind. For eg. data in Mar 2017 for [Date Purchased] should link with data in Feb 2017 for [Date Ordered]. if common fields were not a problem then this was solved by marcowedel‌ by connecting with monthname([Date Ordered],1) -----monthname([Date Purchased]) Thank you Marco for your help.

Purchase	Sales
Country	Country
Region	Region
Payment Group	Payment Group
Date Purchased	Date Ordered
Sales	COGS
Row Count	Expenses

to sum it up my req is to sum(COGS) Dec 2016[Date Ordered] for Jan 2017[Date Purchased], Jan 2017[Date Ordered] for Feb 2017[Date Purchased] and so on as suggested below. Purchased month is just a monthstart aggregate. how do I achieve it. Any help would be great.

Re: How to associate 2 tables with diff dates

sunny_talwar — Wed, 08 Nov 2017 15:48:18 GMT

Can you check if attached looks like what you wanted

Re: How to associate 2 tables with diff dates

Anonymous — Wed, 08 Nov 2017 20:02:55 GMT

Thank you sunny for taking the time to go through and for your swift and accurate answer as always.

Regards. this made my day.

topic Re: How to associate 2 tables with diff dates in QlikView

How to associate 2 tables with diff dates

Re: How to associate 2 tables with diff dates

Re: How to associate 2 tables with diff dates