topic Re: Pivot Table in QlikView

Pivot Table

tyagishaila — Wed, 10 Dec 2014 06:44:25 GMT

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

mato32188 — Wed, 10 Dec 2014 06:47:21 GMT

Hi Shaila,

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

Wed, 10 Dec 2014 06:47:26 GMT

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 — Wed, 10 Dec 2014 06:48:16 GMT

Check this link

prma7799 — Wed, 10 Dec 2014 06:50:07 GMT

Hi,

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

Thanks

tyagishaila — Wed, 10 Dec 2014 06:57:24 GMT

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

SunilChauhan — Wed, 10 Dec 2014 07:01:21 GMT

sum(Total<dimensionfield>amount)

prma7799 — Wed, 10 Dec 2014 07:10:00 GMT

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

tyagishaila — Thu, 11 Dec 2014 03:36:02 GMT

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>