topic Re: pivot table in QlikView

pivot table

nareshthavidishetty — Thu, 24 Dec 2015 06:13:20 GMT

Hi all,

i want to display grand total on total in the pivot table i know there is no possibility of total mode in expr tab

is there any other option can any one tell me

tresB — Thu, 24 Dec 2015 06:22:36 GMT

Perhaps there is. Try to share a sample qvw explaining your expected output.

Anonymous — Thu, 24 Dec 2015 06:22:53 GMT

Pivot Table -> Properties ->Presentation -> Select Dimension from Top Left -> Check Show Partial Sum

nareshthavidishetty — Thu, 24 Dec 2015 06:27:09 GMT

Hi Balraj, i dont need partial sums i need grand total on the totals

looking for row wise

Anonymous — Thu, 24 Dec 2015 06:29:11 GMT

Well, as Tresesco asked, share a samle QVW

tresB — Thu, 24 Dec 2015 06:37:04 GMT

Try using aggr(), like:

=Sum(Aggr(Avg(Value),Dim))

Now, if you enable partial sum, you get sum-of-rows in total.

nareshthavidishetty — Thu, 24 Dec 2015 06:43:52 GMT

thanks treseco i vll try and let u know