Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Not applicable

Pivot Table issue

I have sample Excel file and the Qvw attached.

I am using the Pivot table but the partial sum is showing blank instead of the total sum of that row.Can anyone hep me here ?

Thanks,

Alva.

1 Solution

Accepted Solutions

Re: Pivot Table issue

Try using an aggregation function such as Sum or Count

=Sum(Value)


Capture.PNG

View solution in original post

6 Replies
Frank_Hartmann
Honored Contributor II

Re: Pivot Table issue

just use sum(value) as expression!

hope this helps

Re: Pivot Table issue

Try using an aggregation function such as Sum or Count

=Sum(Value)


Capture.PNG

View solution in original post

Not applicable

Re: Pivot Table issue

change the expression for =sum(Value)

Not applicable

Re: Pivot Table issue

Thanks much

Not applicable

Re: Pivot Table issue

Thanks much

Not applicable

Re: Pivot Table issue

Thanks much