Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

Re: Re: Create 1 calendar with 2 date tables

Hi Rohit,

You can find my full file attached to the post of Muhammad.

Thanks for your help

Regards,

Paul

Highlighted
MVP
MVP

Re: Create 1 calendar with 2 date tables

Check enclosed file....

Highlighted
arsal_90
Contributor III

Re: Create 1 calendar with 2 date tables

Please follow this document and i can't help if you don't provide the data.and you do the right thing but only you have to do is that in link part of your script you have to make flag and also comment date field in fact table. Hope this help

Highlighted
mahesh_agrawal
Contributor

Re: Create 1 calendar with 2 date tables

Hi,

Please go through the changes made in the Facts tab in the script.

I think it will solve your issue.

Highlighted
Partner
Partner

Re: Re: Create 1 calendar with 2 date tables

Hi,

Not yet, is still lot of sync keys in there

Please find attached

Regards,

Paul

Highlighted
mahesh_agrawal
Contributor

Re: Re: Re: Create 1 calendar with 2 date tables

Hi,

Please go through the changes made in the Facts tab in the script.

I think it will solve your issue.

Here I have droped ID and Date from Facts and AmountFacts table.

Now it will work.

Partner
Partner

Re: Re: Re: Re: Create 1 calendar with 2 date tables

Hi Manesh,

Thanks the structure looks good! But the output unfortunately not. If you look at the first tab of the dashboard (Prioritize) you see the listbox on the top left with a count, the total is 250 but I only have 50 projects so everything is times 5.

Also If you look at the table below you see every ID has 2 lines, one with the info and one with the budget (from the other table).

So something is not going correct with creating everything. Any ideas?

Regards,

Paul

Highlighted
Partner
Partner

Re: Re: Re: Re: Re: Create 1 calendar with 2 date tables

Hi,

I think I al most have it. Structure looks good.

But for some reason it won't match all the keys from the fact table to the link table. It will only do when they are the same. This is because of the Left Join I think.

But how can I solve it?

Regards,

Paul

Highlighted
Partner
Partner

Re: Re: Re: Re: Re: Create 1 calendar with 2 date tables

Any ideas guys?