Calculate number of times a value exists with in a given criteria

[#1]

I have a ticket system, where there are various status for the tickets. Im trying to create a table that counts the number of times a status occur within each month.

Specifically Im attempting to create a table that gives me a count of Closed, New, and Open tickets for each YEARMONTH. How do I accomplish that?

The status options

• Cancelled
• Closed
• Needs Approval
• On-hold (3rd party)
• On-hold (me)
• On-hold (ready for test)
• Open
• Open (3rd party responds recieved)
• Resolved

I have a column for each Ticket_ID, which is called CLOSED_YEARMONTH, and OPEN_YEARMONTH, which I expect is to be used.

Thank you for your time and effort.

Best regards,

Philip Hoyos

[Gysbert_Wassenaar]

Can you post an example? Please read this document:

• Preparing examples for Upload - Reduction and Data Scrambling.

[#3]

I realized that my question was not quite specific, and I tried to delete this one and create a new that is more specific. Though I cannot delete this one - so here is the link to the sample data - and more to the point question.

http://community.qlik.com/message/366547#366547