topic Re: Master Calendar causing a loop in QlikView

Master Calendar causing a loop

Anonymous — Mon, 17 Nov 2014 14:36:57 GMT

Hi guys,

I know this is a subject much talked about but I cannot figure out where i am going wrong.

I have created a table for my master calendar and I've created specific tables which contain the UniqueID and the date. I have then tried to join these dates onto the master calendar table but for some reason this is creating a loop! Screenshot of the table layout is attached which should make this clearer..

Can anyone help?

Thanks

Re: Master Calendar causing a loop

jpenuliar — Mon, 17 Nov 2014 14:56:53 GMT

Try having a Master Calendar for your Orders Entered and another master for Returns.

Re: Master Calendar causing a loop

jpenuliar — Mon, 17 Nov 2014 14:59:01 GMT

You can have multiple Master calendars to link to each Date fields you have in your table.:

have a bit of reading on the link:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Re: Master Calendar causing a loop

Anonymous — Mon, 17 Nov 2014 15:01:02 GMT

The only thing is. What if I have two tabs in my document and I want to create list boxes for the Day/Month/Year. What i want is if you choose items in the list boxes i want them to link to the other tabs.

Does this makes sense?

Re: Master Calendar causing a loop

marcus_malinow — Mon, 17 Nov 2014 15:03:37 GMT

Hi Jamel,

you might want to try creating either a concatenated fact table, or a link table. There are many resources on this site to help you do this. You then can link the calendar to a single field in your concatenated fact or link table.

Marcus

Re: Master Calendar causing a loop

jpenuliar — Mon, 17 Nov 2014 15:03:49 GMT

in that case, you can try Canon Dates:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Re: Master Calendar causing a loop

jpenuliar — Mon, 17 Nov 2014 15:12:07 GMT

I try to think of a Master Calendar as a Lookup table for the specific date field attached to it.

so it should be exclusively linked to one field.