topic How to Filter the month in QlikView

How to Filter the month

Wed, 02 May 2012 12:35:26 GMT

How to Filter the month to January of the current year through the last complete month

Examples:

for January 2012 you would pull December 2011 YTD info

for February 2012 you would pull January 2012 and February 2012 YTD info

for March 2012 you would pull Jan 2012, Feb 2012 and Mar 2012 YTD info

The change should be applied to all the years.

Example:--

For Feb 2008----Jan2008 and Feb 2008

For Mar 2009---- Jan to Mar 2009…and so on.

But the data should be displayed only for months which are complete/over.

As in if user is selecting May 2012…and the system date is May 1st,that means, month may is still not over, and thus the data should be displayed for only Jan 2012 to April 2012.

How to Filter the month

CELAMBARASAN — Wed, 02 May 2012 13:12:40 GMT

Create a variable and assign the expression as vMaxDate=Nummin(Max(DateField),MonthEnd(Today(),-1))

Expression as

Sum({<DateField={">=$(=YearStart($(=vMaxDate)))<=$(=vMaxDate)"},YearField=,MonthField=>} Sales)

Celambarasan

How to Filter the month

Wed, 02 May 2012 13:29:36 GMT

Hi ,

I want this as a seperate field. So that i can include month as a field in multi box.

How to Filter the month

Thu, 03 May 2012 05:25:01 GMT

Hi,

i want this to be included in the multi box, so that whenever i click month ,it will show the corresponding months. How can i achieve this