Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-02-25 05:42 AM

Special Counting

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,



test.qvw
842 Views
0 Likes
0 Replies