topic Re: Master Calendar Link not working for Sales Date in QlikView

Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 13:00:54 GMT

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.

Re: Master Calendar Link not working for Sales Date

Gysbert_Wassenaar — Wed, 09 Sep 2015 13:08:07 GMT

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

Re: Master Calendar Link not working for Sales Date

malini_qlikview — Wed, 09 Sep 2015 13:16:46 GMT

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

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:42:30 GMT

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

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:44:10 GMT

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

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:47:11 GMT

the issue may be related to the synthetic key that exists

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:49:14 GMT

Hi Adam,

In the new QVW there are no Synthetic keys.

Regards,

Keerthi KS

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:50:30 GMT

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

Re: Master Calendar Link not working for Sales Date

Wed, 09 Sep 2015 18:59:08 GMT

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

Re: Master Calendar Link not working for Sales Date

Thu, 10 Sep 2015 05:26:48 GMT

Hi All,

Can someone please help me on the above issue.

Regards,

Keerthi KS

Re: Master Calendar Link not working for Sales Date

jagan — Thu, 10 Sep 2015 07:49:30 GMT

Hi,

Can you explain what you are trying to do? What is not working? When I am selecting Sale_Date data is filtering and Post_dates are also filtering.

Regards,

Jagan.

Re: Master Calendar Link not working for Sales Date

Thu, 10 Sep 2015 07:52:45 GMT

Hi Jagan,

But its not filtering properly. As you can see the dates are not matching.

It is matching with the Pay_Date but not with the Sale_Date

Regards,

Keerthi KS

Re: Master Calendar Link not working for Sales Date

jagan — Thu, 10 Sep 2015 08:07:53 GMT

HI Keerthi,

Are you expecting the same value in all the fields Pay_Date, Sale_Date and Posting_Date. Can you come up with an example?

Regards,

Jagan.

Re: Master Calendar Link not working for Sales Date

Thu, 10 Sep 2015 08:51:00 GMT

If i select Date in the Master Calendar, those dates has to be matched with the Sale_Date.

If you select any date from the Date or Posting Date, Pay_date also filters based on that date. Whereas Sale_Date shows some other dates.

Year is selected from the Master Calendar. Sale_date will not be filtered based on Year.

Re: Master Calendar Link not working for Sales Date

jonathandienst — Thu, 10 Sep 2015 09:04:35 GMT

I strongly recommend that you read this article and follow the suggestions for how to handle multiple dates:\

Canonical Date

Re: Master Calendar Link not working for Sales Date

jagan — Thu, 10 Sep 2015 09:20:41 GMT

Hi,

As jonathan dienst suggested try Canonical date.

Regards,

Jagan.