topic Re: Need help Link Table!! in QlikView

Need help Link Table!!

Sun, 21 Apr 2013 02:13:25 GMT

Hi,

I really need help!

I have 2 facts tables : Sales & Budget and 1 store common dimension

The Grain of the Sales fact table is : YYYYMMDD and the grain of the Budget Table is : YYYYMM

I create a table link but my dimension time doesn't work. No datas for years.

Could you please help me ?

Thanks in advance.

Re: Need help Link Table!!

jolivares — Sun, 21 Apr 2013 22:01:26 GMT

First complete the date for budget YYYYMMDD, where DD is first date of the month or the last, second when you make your expressions they should be by month not by day, so you have, i think dayly sales, but no the budget.

The link table try to make concatenating the values of budget and sales.

Re: Need help Link Table!!

kaushiknsolanki — Mon, 22 Apr 2013 06:33:22 GMT

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki

Re: Need help Link Table!!

Mon, 22 Apr 2013 07:21:22 GMT

Hi,

Try the attached file

Re: Need help Link Table!!

Mon, 22 Apr 2013 15:58:12 GMT

Thanks Kaushik and Sampath.

Now, I see the construction. The method is particular but powerful !!

Many Thanks.

Re: Need help Link Table!!

kaushiknsolanki — Mon, 22 Apr 2013 16:38:04 GMT

Hi,

Kindly close the post by marking this as correct answer, if you got the solution.

Regards,

Kaushik Solanki