Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pauldamen
Partner
Partner

Create 1 calendar with 2 date tables

Hi,

I have a script with a fact table and a different table with amounts. De fact table is linked to the Amount table with a ProjectID.

Also linked to the fact table is a master calendar based on the date field in the fact table. Now I have a date field in the Amount table as well (DateAmount).

How can I get this linked to the master calendar as well without creating loops etc? I searched the forum but couldn't find an answer that would help me fix it.

Thanks for your help!

Regards,

Paul

Capture.PNG.png

18 Replies
pauldamen
Partner
Partner
Author

Hi Rohit,

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

Thanks for your help

Regards,

Paul

MK_QSL
MVP
MVP

Check enclosed file....

arsal_90
Creator III
Creator III

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

mahesh_agrawal
Creator
Creator

Hi,

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

I think it will solve your issue.

pauldamen
Partner
Partner
Author

Hi,

Not yet, is still lot of sync keys in there

Please find attached

Regards,

Paul

mahesh_agrawal
Creator
Creator

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.

pauldamen
Partner
Partner
Author

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

pauldamen
Partner
Partner
Author

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

pauldamen
Partner
Partner
Author

Any ideas guys?