Filter Previous month Nprinintg

[qlikuser22]

HI

I want to filter last 6 months data except current month. 

I used this expression:

Advanced Search: =[Date] >= MonthStart(Today(),-6). This expression includes the current month also. 

Example. If current month is June 2020. 

I want to extract last 6 months data like Dec 2019 to May 2020. The current month should not be included. 

Please help. 

[Ruggero_Piccoli · Accepted solution]

Hi,

=[Date] >= MonthStart(Today(),-6) and [Date] < MonthStart(Today())

You can use the "and" and customize the two formulas based on your needs.

Best Regards,

Ruggero

[qlikuser22]

Perfect!! Thanks a lot 🙂 I am new to Nprinitng. Learning many things. Thanks again!!

[Ruggero_Piccoli]

Hi,

This is Qlik Sense advanced search so you have to refer to Qlik Sense documentation and I also suggest to test the expressions in the source Qlik Sense app.

Best Regards,

Ruggero

[qlikuser22]

Thanks for your support. 

I struggled a lot with the filter, but with Qlik community help I was able to do it. I would like to share the results,

ADVANCED FILTER:

Current Month:

=[FIELD_NAME] >= MonthStart(Today())

Previous Month:

=[FIELD_NAME] >= MonthStart(Today(), -1) and [FIELD_NAME] < MonthStart(Today())

Rolling 12 Months Except Current Month:

=[FIELD_NAME] >= MonthStart(Today(), -12) and [FIELD_NAME] < MonthStart(Today())

Rolling 12 Months Including Current Month:

=[FIELD_NAME] >= MonthStart(Today(), -12)

Thanks 🙂