Date selection

Thu, 16 Sep 2010 11:26:51 GMT

Hi ,

We have a table which has request created time,Request closed time ,status everything in the same table.

We want a kind of trend report which should display for duration the closed and Open count. For ex the grpah should display Jan month 20 closed tickets and 10 open tickets similary for the other months.

Do i need to create the calender control seprately irrespective of the Requested Created time and closed time and use the same to get the graph or is there any other way.

Since the Ticket might have raised on Jan month and closed on Feb month. The ticket should contribute to open count in Jan Month and same ticket should contribute to Closed count in Feb month.

Any idea how the same can be achieved.

Regards,XXX

Date selection

johnw — Fri, 17 Sep 2010 01:08:26 GMT

I'd handle it with data model changes. See my posts in this thread:

http://community.qlik.com/forums/t/34115.aspx

Date selection

Fri, 17 Sep 2010 06:56:25 GMT

Hi John,

Yes it was what i was looking for. In addition to created and Resolved time we have some more time stamps.

regards,XXX

topic Date selection in QlikView

Date selection

Date selection

Date selection