Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kmcgovern1
Contributor

Multiple dates in separate tables

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!

1 Solution

Accepted Solutions
chiru_thota
Valued Contributor

Re: Multiple dates in separate tables

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

QCom1.jpg

3 Replies
praveenavelagap
Contributor III

Re: Multiple dates in separate tables

hi,

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

Not applicable

Re: Multiple dates in separate tables

hi Kevin

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

chiru_thota
Valued Contributor

Re: Multiple dates in separate tables

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

QCom1.jpg

Community Browser