How to get last 12 months of data by using filter?

[Qiyanlu66]

Hello everyone,

If I want to get last 12 months of data of vCurDate,

is there any way I can do this? I am not sure how to set up the range of date in the filter.

Thank you very much.

[Lech_Miszkiewicz]

on the other hand...

It would be usefull to see how you create your month/year field as depending on that my suggestion may be wrong. If you used:

• Date(Floor(MonthStart([yourdatefield]),'YYYY-MMM')) as MonthYear

or

• Date(MonthStart([yourdatefield]),'YYYY-MMM') as MonthYear

then it should be ok. I tend to make sure that timestamp part of any date is removed that is why i always use Floor() to remove it..

[Qiyanlu66]

I have tried set Numerical value is: Floor(AddMonths(monthstart(Today()),0))
But it keep gives me error meesge of :
Something went wrong with the current operation.
when I click on save button.

tbh, I'm not sure how we created our month/year field, is there any way I could check it on the nprinting side? I didn't touch the Qlik Sense part.

[Lech_Miszkiewicz · Accepted solution]

Hi

my  apologies i should say "evaluate value" as we talking about formula here

[Lech_Miszkiewicz]

regarding the field creation - you need to look at Qlik Sense application script.. or you can look at data model viewer and click on the field. Then you should see the tags which should say: numerical, timestamp, date etc.... 

[Qiyanlu66]

Thank you very much, I got it work.

[Lech_Miszkiewicz]

Well done mate 🙂

Cheers

[qlikuser22]

HI. Even I have the same issue. I want to extract the last 12 months data from current month.

Example. If the current month is June. I want last 12 months data to be selected. 

Advanced Search is : =Floor(AddMonths(monthstart(Today()),-12))

I am able to get the result but not a correct one. 

Also I tried with Numeric Value is option, but it says this expression can't be accepted because its not numeric. 

[Lech_Miszkiewicz]

Hi @qlikuser22 

We dont know your datamodel and how you are applying your filters... If you use filter as you say being =Floor(AddMonths(monthstart(Today()),-12)) all what you select is only single month 12 months ago...

I suggest you read post from my blog where I explain Advanced search options: https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

[Ruggero_Piccoli]

Hi,

Please open a new conversation for new question. The original question is two years old and the software evolved a lot. A new question will also let you to add all details that will help us to understand and to specify the correct version lables.

Best Regards,

Ruggero

[qlikuser22]

HI. Can you post your solution. I have the same issue as yours. Extracting last 12 months.