I'm still relatively new to Qlikview and I have a pivot table where I have two dimensions on the left and one dimension at the top as columns. The columns are years that I'm comparing and the dimensions to the left describe a type of sale. I'm trying to compare sales from one year to the next and I've used the After() function in order to see a comparison (SUM([Units])-After(SUM([Units]))) and this works ok, but I have a column under last year's data that just basically has a null value of "-" and I was curious to know if this can be removed or if there is a better way to do the comparison. I realize it's looking for the next value to evaluate and it's obviously not there.
I think what you wrote would probably work if my years were numeric, but they aren't. It's actually a fiscal year and so they look like this: "Fiscal Year 1213". I realize that I could manipulate the data column before Qlikview loads it and make it numeric, but it won't work with what I'm trying to do. Is there another way to do it?
I thought since you used MAX here that TOP would work as if the data was sorted A-Z and so it would take the top value, but that didn't work either. Any other ideas?