Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Current Month vs Previous Month Value

Hi!

I want to compare Current Month Value vs Previous Month Value. I made a question 2 days ago for a Current Month vs Previous Month Total Tickets : Get how many tickets were generated in the month before the chosen one

I did that. I created a 2 news fields:

Month(Fecha_Crea) as FechaMonth,

Num(Month(Fecha_Crea)) as Num_Fecha,



Now, I have to compare a different field: 'SLA'. To get SLA, I have this expression:

Count({$<Cumplimiento={'CUMPLIÓ'}>} Ticket)/Count(TOTAL Ticket) . It shows me SLA of Current Month

Now, I want to get a SLA of Previous Month. I did this:

Count({< Num_Fecha = {  $(=Max(Num_Fecha) - 1)}>+$<Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket)/Count(TOTAL Ticket)

But it doesn't work.

My expression to get a Current Month Total Tickets is :

Count({  < Num_Fecha = {  $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month] >}Ticket)


I hope u can help me.

Thanks

1 Solution

Accepted Solutions
francescoreggia
Partner - Contributor III
Partner - Contributor III

Sorry


Count({< Num_Fecha = {  $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket) /

Count(TOTAL {< Num_Fecha = {  $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month]>} Ticket)

View solution in original post

5 Replies
francescoreggia
Partner - Contributor III
Partner - Contributor III

Try

Count({< Num_Fecha = {  $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket)/Count(TOTAL Ticket)

Anonymous
Not applicable
Author

It shows me a wrong number 😕

MarioCenteno
Creator III
Creator III

Hi @Frantz Gonzales

You could try something like that:

Count({$<[Cumplimiento]={'CUMPLIO'},[Fecha_crea.autoCalendar.Date]=

{'>=$(=AddMonths(MonthStart(Today()),-2))<=$(=AddMonths(MonthEnd (Today()),-2))'}>}Ticket/Count(TOTAL Ticket)

Mario Centeno

francescoreggia
Partner - Contributor III
Partner - Contributor III

Sorry


Count({< Num_Fecha = {  $(=Max(Num_Fecha) - 1)},Cumplimiento={'CUMPLIÓ'},[Fecha_Crea.autoCalendar.Month]>}Ticket) /

Count(TOTAL {< Num_Fecha = {  $(=Max(Num_Fecha) - 1)},[Fecha_Crea.autoCalendar.Month]>} Ticket)

Anonymous
Not applicable
Author

It works ! Thanks!