Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot subtraction question

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.

3 Replies
dennisnet
Partner
Partner

Did you try something like:

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

?

dennisnet
Partner
Partner

See attached file:

Here I used :

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

I hope it is helpfull
Good Luck.


Not applicable
Author

thank you both, it was very helpful.