topic Before Function in QlikView

Before Function

tmumaw — Wed, 26 Oct 2016 15:09:57 GMT

Morning everyone,

Question for you all. I am using this statement:

Sum({<Wkend = {1}>} Billed) - Before(Sum({<Wkend = {1}>} Billed))

What is weird in 2016 I have 433,316 and my before column for 2015 is 918,177......the statement is giving me an answer of (801,327). Any ideas what I am doing wrong? I am using it in a pivot table with dimensions of year and week.

Thanks

Re: Before Function

sunny_talwar — Wed, 26 Oct 2016 15:12:29 GMT

Both Year and Week are pivoted? May be you need to add TOTAL

Sum({<Wkend = {1}>} Billed) - Before(TOTAL Sum({<Wkend = {1}>} Billed))

Re: Before Function

tmumaw — Wed, 26 Oct 2016 15:24:52 GMT

Nope

Re: Before Function

sunny_talwar — Wed, 26 Oct 2016 15:25:39 GMT

Can you may be post a sample or an image?

Re: Before Function

tmumaw — Wed, 26 Oct 2016 15:30:16 GMT

Re: Before Function

sunny_talwar — Wed, 26 Oct 2016 15:33:45 GMT

hmmm, its weird.... What if you add this as your expression? Do you see the value from last year?

Before(Sum({<Wkend = {1}>} Billed))

Re: Before Function

tmumaw — Wed, 26 Oct 2016 15:38:50 GMT

Really weird.....

Re: Before Function

sunny_talwar — Wed, 26 Oct 2016 15:46:37 GMT

I have no idea what it might be. Unless you can share a sample, I am out of ideas

Re: Before Function

tmumaw — Wed, 26 Oct 2016 15:49:54 GMT

Okay my mistake forgot the set analysis piece in the before column

Re: Before Function

sunny_talwar — Wed, 26 Oct 2016 16:09:52 GMT

So it seems to be working now? Right?