Discussion Board for collaboration related to QlikView App Development.
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.
Did you try something like:
Below(Sum(Player)) - Sum(Player)
See attached file:
Here I used :
SUM(field) - Below(column(1))
I hope it is helpfullGood Luck.
thank you both, it was very helpful.