topic Re: Associate months from different tables in QlikView

Associate months from different tables

walterlh — Fri, 27 Dec 2013 11:54:18 GMT

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

Re: Associate months from different tables

Anonymous — Fri, 27 Dec 2013 13:23:36 GMT

Walter

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

Best Regards, Bill

Re: Associate months from different tables

Gysbert_Wassenaar — Fri, 27 Dec 2013 13:25:22 GMT

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.

Re: Associate months from different tables

walterlh — Fri, 27 Dec 2013 14:08:09 GMT

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

This is the file, I hope you can help me

Re: Associate months from different tables

walterlh — Fri, 27 Dec 2013 14:09:33 GMT

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