The Before function and Sort Groups

[#1]

Hi every one, I am currently having an issue with the Before function, when I use the function I am not getting the previous data that I expect to receive back, ex: Before(Spend, 1), actually I am receiving Null values.

I did a little research and found that this function seems  only to work  with in each sort group and will not see values outside of the group.  Currently my data is grouped by a year range, so my questions is if I cannot use the before function to get the data from a different sort group for a specific value how can this be done in Qlikview,??

Here is an example of the expression I am looking to create:

if((Spend <> 0 OR Spend <> NULL()) OR (Before(Spend, 1) <> 0 OR Before(Spend, 1) <> NULL()),Spend/Before(Spend, 1)-1)

The before spend is located in a different group from where  I am running the expression.

Thanks for your help.

[Gysbert_Wassenaar]

Try Before(TOTAL Spend, 1) to cross the dimension borders

[swuehl]

Are you using Year in a horizontal dimension (i.e. pivoted to the top)? If not, you need to use Above() instead of Before().

And how many dimensions are you using? Could you upload a small sample QVW or at least a screenshot?