topic Re: Problem with the total option in pivot table in QlikView

Problem with the total option in pivot table

Thu, 20 Dec 2012 07:15:46 GMT

hi,

I am using pivot table for the UI,but the problem is total is not displaying correctly.plz help me to solve it

Thanks in advance

Re: Problem with the total option in pivot table

er_mohit — Thu, 20 Dec 2012 07:20:01 GMT

i didnt get you exactly.. explain it

whether you trying to check overall total or sub total???

Re: Problem with the total option in pivot table

Thu, 20 Dec 2012 07:22:06 GMT

Sorry,I am trying to check the overall total,sub total is working fine.

thanks

Re: Problem with the total option in pivot table

Thu, 20 Dec 2012 07:32:48 GMT

firstly go to the dimension of pivote and select PARTIAL SUM then go to the expression and write sum(fieldname) then both total and sub total are displayed

hope it will help you

Re: Problem with the total option in pivot table

er_mohit — Thu, 20 Dec 2012 07:42:17 GMT

ok.

for this overall total which field you take as a dimension on chart with corresponding you want to check over aal total then you just see in attached image

hope this will help you

as in my image i hav to check overall total correspong to mat _id

Re: Problem with the total option in pivot table

Thu, 20 Dec 2012 07:57:43 GMT

thanks, i have already done that.sub total it is displaying correctly but main total is displaying wrongly.

Re: Problem with the total option in pivot table

er_mohit — Thu, 20 Dec 2012 08:03:04 GMT

in all fields where you use sum function write in expression

sum(total fieldname)

hope it helps you

Re: Problem with the total option in pivot table

Thu, 20 Dec 2012 08:08:41 GMT

i think you miss Total() function try it.

sum(Total(field))