topic Re: Restricting Rolling Months Value in QlikView

Restricting Rolling Months Value

alkesh_sharma — Thu, 20 Feb 2014 08:03:21 GMT

Hello, I need help reg. restricting values in rolling month.

I have data for five years, but i need to display the values of Rolling months for last 2yrs (24 month) in a list box.

Thanx in advance.

Re: Restricting Rolling Months Value

Thu, 20 Feb 2014 08:07:44 GMT

If you are displaying only 24 months data throughout your application then filter remaining 3 yrs data from data model itself. It will help to show desired results, also it will reduce size of the application.

Re: Restricting Rolling Months Value

alexandros17 — Thu, 20 Feb 2014 08:07:57 GMT

write this expression in your list box instead of input the field

=if(Year > year(today())-2, Year, null())

Re: Restricting Rolling Months Value

amit_saini — Thu, 20 Feb 2014 08:12:07 GMT

Hi Alkesh,

Try This:

if(makedate(Year,POPER)>=monthstart(addmonths(Today(), -23)) and makedate(Year,POPER)<=MonthEnd(Today()), 1, 0) as %isRollingMonth

Thanks,

Re: Restricting Rolling Months Value

alexandros17 — Thu, 20 Feb 2014 08:19:57 GMT

Excuse me I was wrong, try this

=If(myDate > AddMonths(Today(),-84), MonthYear, null())

Re: Restricting Rolling Months Value

alkesh_sharma — Thu, 20 Feb 2014 09:07:25 GMT

This solved the problem....Thanx