The Before function and Sort Groups

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: The Before function and Sort Groups

Gysbert_Wassenaar — Mon, 04 Apr 2016 17:17:04 GMT

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

Re: The Before function and Sort Groups

swuehl — Mon, 04 Apr 2016 17:25:30 GMT

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?

topic Re: The Before function and Sort Groups in QlikView

The Before function and Sort Groups

Re: The Before function and Sort Groups

Re: The Before function and Sort Groups