Special Counting

Thu, 25 Feb 2010 10:42:55 GMT

Dear All,

I have table as you can see in the attached file. Each ID has a history action as below :

Analyst_Test

Waiting_Information

IT_Under_Development

IT_Under_Planning

Delivery_Bekleniyor

Postponed

Developing

Case_Closed

User_Test

Waiting_Authorization

Rejected

Drop_Out

I would like to show below issues on a chart.:

To count the ids which are under user_test over 3 (or n) days.
To count the ids which are under analyst_test over 3 (or n) days.
To count the ids which doesn't have any action more than 2 weeks.
To count the ids which has IT_Under_Planning state and has not Case_Closed state for more than 6 weeks.

Please note that each id has several action type with different dates. So the above requirements must be based on ids which has the latest action.

Thanks for your support.

Best Regards,

topic Special Counting in QlikView