Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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.