Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tyagishaila
Specialist
Specialist

Pivot Table

Hi,

I am new in qlikview. Please Help me out to get the value of partial sum in pivot table.

I need those values in my expression calculation.

Thanks

8 Replies
mato32188
Specialist
Specialist

Hi Shaila,

in Presentation tab is check box Show Partial Sums... use it on level, you need to show values.

BR

M

ECG line chart is the most important visualization in your life.
Not applicable

Hi

first create an expression sum(yourdesiredfield) and in the presentation tab enable show partial sum option for this expresion.

it will reflect in the chart

anbu1984
Master III
Master III

prma7799
Master III
Master III

Hi,

click right click on pivot table > presentation > tick show partial sum.

Thanks

tyagishaila
Specialist
Specialist
Author

Yes I know about option of partial sum,

but I need this value in my Expression calculation.

I want to know how can I take this value, i.e. expression for partial sum

TigerisBack
Champion
Champion

sum(Total<dimensionfield>amount)

prma7799
Master III
Master III

sum(Total<CalendarYear>[Total Sale Amount])

tyagishaila
Specialist
Specialist
Author

Thank You Anbu

But My requirement is little bit different. I want to use the value in my

next expression which comes after partial sum.

I want to find %.

Shaila

On Wed, Dec 10, 2014 at 7:44 PM, anbu cheliyan <qcwebmaster@qlikview.com>