topic After and Below functions in QlikView

After and Below functions

Thu, 24 Feb 2011 09:21:11 GMT

I take in dimension Month and expression

(sum([sales]) - after(sum([sales]))) / after(sum([sales]))

but it's not working like this before is also not working

tell me some solusions

thanks and best regards

Thu, 24 Feb 2011 09:25:33 GMT

Can you share you application ..... and whats the problem please describe ???

Thu, 24 Feb 2011 09:33:57 GMT

I want to compare SALES of present month to previous month (through after function)

Thu, 24 Feb 2011 09:45:35 GMT

After function works like this

for example B : after(A)

Filed A : 1 2 3 4 5 6

Field B: 2 3 4 5 6 _

(sum(a) - sum(b) ) / sum (b)

I hope you want to calculate the same ??? but check before that your after function is working properly and values are coming on to it.

Thu, 24 Feb 2011 10:02:18 GMT

Ya Like this but when i use the after function the value is not coming (null)

thanks and regard

Thu, 24 Feb 2011 12:03:31 GMT

after function works on row wise .....

i think you should use Above() function for the same in your script.

(sum(A) - above(sum(A) ) / above(sum(A))

PLease let me know if it works ..... and if not i suggest u should share you application , i will make it for you 🙂