Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Sergey_Shuklin
Valued Contributor

Re: Counting number of tickets opened in a month

Hello, Tiia!

Can you provide some data sample (scrambled or manually generated), which will fit your original data. Beacause there are multiple solutions depend on which data you have.

Highlighted
Not applicable

Re: Counting number of tickets opened in a month

Here's how I solved this:

Measure:

count({<[Resolution Category Tier 1]={NameOfTheCategory}

, [IncidentReportedMonth] = {"$(=$(vPreviousMonth))"}

}>}[Incident ID])

Variable:

vPreviousMonth=MonthStart((AddMonths(Today(),-1)))

In Data Load Editor:

monthstart(date([Submit Date])) as [IncidentReportedMonth]

     where [Submit Date] is column name where ticket's opening date is.