Multiple dates in separate tables

Anonymous — Fri, 27 Jul 2012 15:53:21 GMT

Hi all, I've been working on this problem for close to a day and reading as much as possible about potential solutions but I've been unable to get to a solution that I like. I'm hoping someone can give me some good outsider perspective into what I might be able to do here. The problem is that I have dates in different tables but want to be able to compare the associated dollar amount in each table based on one date.

So to explain, I have a fact table with two tables branched off of it using different keys. The branch tables each have dates (which I've associated calendar tables based on the dates) and dollar amounts. The problem I come to is that I want to compare the dollar amounts in both tables but since the date tables are different I can't compare on a common date field. If I create a common date field in a singular table then it ends up generating a circular loop. I can give more info if this still doesn't make sense. Thanks in advance for your help!

Re: Multiple dates in separate tables

Anonymous — Mon, 03 Mar 2014 23:29:10 GMT

hi,

did u find solution to it other than taking filters for both dates separately??

Re: Multiple dates in separate tables

Tue, 04 Mar 2014 00:11:10 GMT

hi Kevin

you Might upload qvw file with an example of this case!!!

Re: Multiple dates in separate tables

chiru_thota — Tue, 04 Mar 2014 02:41:48 GMT

Following data mode may be helpful for you.We are using link table and combing two tables with dates

topic Re: Multiple dates in separate tables in QlikView

Multiple dates in separate tables

Re: Multiple dates in separate tables

Re: Multiple dates in separate tables

Re: Multiple dates in separate tables