Master Calendar Link not working for Sales Date

[#1]

Hi All,

Sales dates are not properly linking with the Master calendar.

In the QVW you can see Sale_Date(Sales tab in the script).

It is linked to master calendar through SalesLink.

SalesLink is joined to Unit_Link in Link Table.

When i select date from Master Calendar, Sale_Date is not filtering based on Date from Master Calendar.

Please help me with the issue.

[Gysbert_Wassenaar]

Sale_Date is not linked to the master calendar. Posting Date is.

[malini_qlikview]

Hi Keerthi,

In the Linktable , the sales data Unit_Link name is not correct. I can see the column Unit_Link1, which is not linked to Projects table.

Try renaming SalesLink as Unit_Link in the 23rd line of LinkTable Tab

[#4]

Hi Malini,

I have renamed and loaded but still its not working. Please find the attached QVW.

Pay_Date is working as expected but Sale_Date is not working.

Please help me with this.

Regards,

Keerthi KS

[#5]

Hi Gysbert,

But Sale_Date is linked to Mater calendar through Posting Date right ?

Please correct me if i am wrong.

In the new QVW Pay_Date is working as expected but Sale_Date is not working.

Regards,

Keerthi KS

[#6]

the issue may be related to the synthetic key that exists

[#7]

Hi  Adam,

In the new QVW there are no Synthetic keys.

Regards,

Keerthi KS

[#8]

sorry - Must be looking at an older version - did not realize

[#9]

Please check with the new QVW. and let me know if there are any mistakes

[#10]

Hi All,

Can someone please help me on the above issue.

Regards,

Keerthi KS