Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

Set Analysis

Hi.

In my example, the pivot table "Ult 4m" I take the current month and the previous 3 months: oct 13, sep 13, ago 13, jul 13. But now I need to take the 3 months without current: sep 13, ago 13 jul 13.

Regards.

1 Solution

Accepted Solutions
rajni_batra
Specialist
Specialist

Try

SUM({1<AñoMes={">$(=Date(AddMonths(Max(AñoMes),-4),'MMM YY'))  <$(=Date((Max(AñoMes)),'MMM YY'))" }>}Cantidad)

Regards,

Rajni

View solution in original post

3 Replies
Anonymous
Not applicable

Sandro

Replace your current dimension with this Calculated Dimension :

     =if ( not month(AñoMes)  = month(today()) , AñoMes )

And Tick Suppress When Value is null.

Best Regards,     Bill

rajni_batra
Specialist
Specialist

Try

SUM({1<AñoMes={">$(=Date(AddMonths(Max(AñoMes),-4),'MMM YY'))  <$(=Date((Max(AñoMes)),'MMM YY'))" }>}Cantidad)

Regards,

Rajni

spividori
Specialist
Specialist
Author

Thanks Rajni, is what I wanted.

Regards.