I need to create filter based on date.

[#1]

I need to create filter based on date. In a table I want to show data with filtered on all dates from previous year until the end date of last full month this year, for example now in march I want the filter to only show data for the  period 2015-01-01 -  2016-02-29. 

Hope you understand my question.

Regards

Mårten

[sunny_talwar]

May be this is helpful: Easy Date Range Selection with Qlikview | Min-Maxing

[Gysbert_Wassenaar]

See this video tutorial: Selecting Arbitrary Date Ranges

[Anonymous]

use to calendar objects one object to select your start date and other one to select end date.

Capture both the  dates in variables like vStart and VEnd.

and use set analysis like below:

=Only( if( MyDate >= $(vStart) AND MyDate <= $(vEnd), name )

or you can use set analysis as well...

[#5]

Thanks all!

I did a flag in the load of the data.

if(Datefield >= YearStart(AddYears(Today(),-1)), if(Datefield <= date(monthend(addmonths(Today(),-1))), 1,0)) as FilterFlag