Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

techvarun
Valued Contributor II

Problem in finding the total

Hi all

                   I have a pivot table with year quarter and month i have computed total profit for monthwise and i need to show the total of all the three month value in last column.

1 Solution

Accepted Solutions
nizamsha
Valued Contributor

Re: Problem in finding the total

see the attachment

14 Replies
techvarun
Valued Contributor II

Re: Problem in finding the total

I need to show the sum of total of month April+May+June in last Column


Thanks in Advance

Re: Problem in finding the total

IN presentation check (near fields list) the field for which you need the sum ... (show partial sum)

hope it helps

Not applicable

Re: Problem in finding the total

Presentation TAB >select Month ---check show partial Sums

techvarun
Valued Contributor II

Re: Problem in finding the total

the total field is a calculated field and i need the sum of all three months also a calculated field

Not applicable

Re: Problem in finding the total

try this

sum( Fieldname)

and in presentation tab select the field month then check show partial  sum.

******************************************************************

or try this

sum(total Fieldname)

techvarun
Valued Contributor II

Re: Problem in finding the total

am getting partial sum but i need the value as a separate column in the end of the table


Regards

techvarun
Valued Contributor II

Re: Problem in finding the total

am getting partial sum but i need the value as a separate column in the end of the table


Regards

Re: Problem in finding the total

add this expression

aggr(sum(Fieldname), year, quarter)

Re: Problem in finding the total

add this expression

aggr(sum(Fieldname), year, quarter)

Community Browser