Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
walterlh
Creator II
Creator II

Associate months from different tables

Hello everyone!. I am having a problem that I assume it should not be too difficult but I can not think of anything. My project is about the financial area, where I have several tables that have dates such as entry date portfolio, portfolio departure, expiration date, date of sale, date of collection, etc.. What I want to achieve is to build a "master calendar" where to select a month to see all flaps document reports that month. I tried to put all the fields the same name to be associated as well but do not leave me with all (not complete recharge) and I always get hung some reports. Please I need help!!

walter

4 Replies
Anonymous
Not applicable

Walter

It is hard to give any suggestion without seeing the data model, any chance of posting the qvw ?

Best Regards,     Bill

Gysbert_Wassenaar

You can probably use a link table for this.See this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars. Another options is a calendar data island.


talk is cheap, supply exceeds demand
walterlh
Creator II
Creator II
Author

http://community.qlik.com/docs/DOC-5593 

This is the file, I hope you can help me

walterlh
Creator II
Creator II
Author

Hello Gysbert Wassenaar. Thanks for your answer! I'll see what you left me and then I'll tell you how I went.