topic Associating the calendar to two dates in QlikView

Associating the calendar to two dates

Mon, 20 Jun 2011 13:57:03 GMT

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

Associating the calendar to two dates

prieper — Mon, 20 Jun 2011 14:25:09 GMT

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

Associating the calendar to two dates

Mon, 20 Jun 2011 20:49:36 GMT

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.

Re: Associating the calendar to two dates

Anonymous — Tue, 28 Aug 2012 05:48:01 GMT

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

Re: Associating the calendar to two dates

daveamz — Tue, 28 Aug 2012 07:03:22 GMT

Hi,

Could you provide a data sample?