Month and Quarter Selection not being ignored

[#1]

Hello:

I have the following expression in which I'm trying to get the prior years revenue at the same point in time as this year. (i.e today is Apr. 23 2011 so I want to see the revenue for last year up to the end of March 2010 for the prior year).

If I take MONTHSORT={'<=$(vPriorPeriod)'} out of the expression below both month and quarter selections that the user can make are ignored but I need this in the expression to get the required dollar values/time period.

I'm new at QlikView and this is my first post so I apolgize in advance if this is a silly question.

My expression:

Money (Sum({$<SCENARIO={'Actual'},GRPCOD={140},MONTH=,QUARTER=,FSCSYR={$(vPriorYear), MONTHSORT={'<=$(vPriorPeriod)'}>} MONTHAMT * -1)

[#2]

Hi Darius:

Yes it's intentionally there as Finance only wants to compare the prior year within the same time frame/period as the current year. (up to the end of the previous month... ie. Apr today provide total amount up to the end of march 2011 for the prior year).

Is there anyway I can do this and have the month/quarter selections ignored?

Thanks Again, Dwight

[d_pranskus]

Why do you think they are not ignored? Because when you select something in month or quarter it has effect on MONTHSORT and it is used seting filter for first expression. ANd actually not month and quarter but MONTHSORT has effect.