topic Re: Need Help Link Table in QlikView

Need Help Link Table

Sun, 21 Apr 2013 02:20:14 GMT

Hi ,

I have 2 facts tables : Sales & Budget and one common dimension. The grain of the sales fact is YYYYMMDD and budget : YYYYMM.

I create a table link but my dimension time doesn't work. Could you please help me ?

I really need help.

Thanks in adavance.

Re: Need Help Link Table

hic — Sun, 21 Apr 2013 10:53:57 GMT

I would not use a link table. I would concatenate the two tables and use a generic key for the calendar dimension. The generic key can be made so that it allows a mixed granularity.

See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

and

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

HIC

Re: Need Help Link Table

Sun, 21 Apr 2013 11:40:39 GMT

Thanks Henric.

I created 2 models.

One using concatenation fact tables. It works good but I would test a second method with link table to compare the scenario.

Re: Need Help Link Table

Sun, 21 Apr 2013 16:55:15 GMT

I find the issue.