Date selection

[#1]

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

[johnw]

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

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

[#3]

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