Regarding shared Calendar

Wed, 26 Nov 2014 21:34:57 GMT

Hello Friends,

I appreciate your time. I am having a sharedcalendar which is sharing 6 dates say DATE-PR,DATE-RFQ,DATE-PO,DATE-GRV,DATE-INVOICE, DATE PAYMENT. I am as of now using a cross table logic for my shared calendar as below:

tabLink:

CrossTable (Datetype, Date,6)

LOAD

//key,

[Date - PR] ,

[Date - RFQ] ,

[Date - PO],

[Date - GRV],

[Date - Invoice],

[Date - Payment],

[Date - PR],

[Date - RFQ],

[Date - PO],

[Date - GRV]

Resident Fact;

left join(Fact)

TABLINK2:

LOAD

Date as Shared_Date,

Datetype,

[Date - PR],

[Date - RFQ],

[Date - PO],

[Date - GRV],

[Date - Invoice],

[Date - Payment]

resident tabLink;

drop table tabLink;

This is working fine, but now I need to include another condition in this as when I click shared date,

, then it need to show only the same date value from other date fields. Let say when I click, 1/1/2014 from shared-date then if it is present in other date fields say in DATE-PR or DATE-RFQ then it need to show the same otherwise it need to get grayed out.

As of now it is showing a lot of other dates along with the selected date in shared calendar, but my scenario is to show only that particular date which I am clicking on the shared-date.

Attached a screenshot for your reference.

Kindly let me know.

Kind regards,

Kiru

Re: Regarding shared Calendar

Wed, 26 Nov 2014 22:36:24 GMT

Guys, please let me know in case if you has any solution.

Kiru

topic Re: Regarding shared Calendar in QlikView

Regarding shared Calendar

Re: Regarding shared Calendar