Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

2 Replies
MVP & Luminary
MVP & Luminary

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

Can you post an example? Please read this document:


talk is cheap, supply exceeds demand
Not applicable

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

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