topic Re: Substract PV Table in QlikView

Substract PV Table

pgalvezt — Fri, 10 Aug 2012 16:19:59 GMT

Hello, How can I do this?

I have an expression gave me different results for months.

Like:

Jan Feb Mar

results 45 48 85

I need a second row with this:

Feb - Jan, Mar-Feb

3 40

and so on.

Thank you

Re: Substract PV Table

pgalvezt — Fri, 10 Aug 2012 17:00:53 GMT

I Put a Jpg image what I want is the difference between periods:

In this case would be -201229027

Re: Substract PV Table

pgalvezt — Fri, 10 Aug 2012 17:47:38 GMT

Any Help?

Re: Substract PV Table

manojkvrajan — Fri, 10 Aug 2012 21:20:31 GMT

I want to double check, if you want to display the monthly value difference in rows or columns.

It is easy to display in columns using the Column() function. However, please provide some more details.

Re: Substract PV Table

pgalvezt — Fri, 10 Aug 2012 21:31:44 GMT

If you take a look to the jpg file you will see what I want. I have selected apr and may both of them show a results but is just one expression. I need the diference of that expression (Sum(Total*[% DD])) and other Row would have the difference like may - apr.