Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.