topic Re: pivot subtraction question in QlikView

pivot subtraction question

Thu, 06 Oct 2011 06:30:09 GMT

Hello,

I like to know if it’s possible to add new column into pivot table that will show me the gap between day1 to day2 to day3 and so on.

in the enclosed file you can see the "base" table that i have in the QV and I add the "expected" table that I like to see.

Thanks in advance.

Anonymous — Thu, 06 Oct 2011 09:10:04 GMT

Did you try something like:

Below(Sum(Player)) - Sum(Player)

Anonymous — Thu, 06 Oct 2011 09:16:23 GMT

See attached file:

Here I used :

SUM(field) - Below(column(1))

I hope it is helpfull
Good Luck.

Thu, 06 Oct 2011 13:34:22 GMT

thank you both, it was very helpful.