topic I need to create filter based on date. in QlikView

I need to create filter based on date.

Wed, 23 Mar 2016 12:14:21 GMT

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

Re: I need to create filter based on date.

sunny_talwar — Wed, 23 Mar 2016 15:48:17 GMT

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

Re: I need to create filter based on date.

Gysbert_Wassenaar — Thu, 24 Mar 2016 07:15:55 GMT

See this video tutorial: Selecting Arbitrary Date Ranges

Re: I need to create filter based on date.

Anonymous — Thu, 24 Mar 2016 08:48:58 GMT

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...

Re: I need to create filter based on date.

Thu, 24 Mar 2016 10:02:18 GMT

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