Associating the calendar to two dates

[#1]

Hello,

I have three dates

1. Query Issued

2. Query Answered

3. Query Closed

I have a master calendar.

When a user selects a date I have to show metrics defined as

1. Days from Query Issued to Query Answered

2. Days from Query Answered to Query Closed

If I join my calendar on Query Issued then I would get the data for the first metric correctly.

But for the second metric, I have to associate the calendar date with Query Answered. How do I do this in Qlikview.

Help regarding this would be greatly appreciated.

Thanks,

Bharath BK

[prieper]

This may depend on your datamodel, if it is like

QueryID, Status, TimeStamp

You only need to put a calendar on the Timestamp.

If your modal looks like

QueryID, Issued, Answered, Closed

you may either need 3 calendars, one for each status, or insert one more column "Last Status" or the like, on which you make the calendar.

HTH
Peter

[#3]

My data looks like

QueryID, Issued, Answered, Closed

Creating a data island seems like a viable solution for my case as for one metric I have to filter on Answered Date and for another metric I have to filter on Closed Date.

But I am not sure of the what the consequences might be after doing so.

[Anonymous]

Hi Bharath, Have you got the solution for your query above, since I have the same scanario and need to overcome. Best, Skumar

[daveamz]

Hi,

Could you provide a data sample?