topic Tax return in QlikView

Tax return

Thu, 04 Mar 2010 21:25:47 GMT

Dear All,

I need to calculate tax return after each month which would be a difference between purchase tax as a new dimension e.g. TaxReturnAmount so that in the following example I'd get 2 in February and -1 in March.

Month, Side, TaxAmount

Jan, Sales, 8

Jan, Purchase, 10

Feb, Sales, 5

Feb, Purchase, 4

Any idea how to calculate it?

BR,

Przemek

Tax return

Thu, 04 Mar 2010 22:31:15 GMT

It looks like an if statement would work.

= sum(if(Side='Sales',-Taxamount,Taxamount))

Tax return

Fri, 05 Mar 2010 08:16:54 GMT

Ben, thanks your reply. The key thing in this exercise is to move the result to next month. In your statement it stays in the original one.

BR,

Przemek