topic One date, multiple tables in QlikView

One date, multiple tables

Tue, 14 Jan 2014 17:33:16 GMT

I'm a bit new to Qlikview, so apologies if this is a stupid question! I have a date field in a master calendar, for which i need linked to 5 or 6 different tables of data.

If I rename the date field so it's the same on each table, I get a huge mess where all the tables are linked to each other. However, I only want each table connecting to the master calendar, not to each other!

How do i do that?

Re: One date, multiple tables

kiranmanoharrode — Tue, 14 Jan 2014 17:42:29 GMT

Hi Alex,

First of all remove all synthetic Keys with use of Composite keys.....and rename all date fields with Master calender's Date field...

Regards
Kiran Rode

+ 91 8976977897

Re: One date, multiple tables

Tue, 14 Jan 2014 17:48:22 GMT

Hey Alex,

You can create a different field in Master calendar for each table. So for example you have three tables 1,2,3 and they each have Date1,Date2, Date3 then in master calendar you could create aliases like Date as Date1, Date as Date2 , Date as Date3.

Hope it was helpful

Thanks

Re: One date, multiple tables

Tue, 14 Jan 2014 17:54:36 GMT

Thanks. Does that means i also need to create multiple versions of all the relative fields, such as CalendarWeek and CalendarMonthEnd?

Re: One date, multiple tables

phaneendra_kunc — Tue, 14 Jan 2014 17:55:56 GMT

Try to get like a star schema...

rename all date fields to a same name....and concatenate all your fact tables if possible, so that you can avoid synthetic keys...

then build your calendar for MIN & MAX date from your fact data...

Re: One date, multiple tables

Tue, 14 Jan 2014 18:12:07 GMT

No.

So what will happen is say if you select MonthYear as Jan-2014 in Master Calendar then all dates in Jan of 2014 in all three tables will be selected.