Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

anilnaidu13
Contributor

Pivot table Total required for only one expression Partial sum not for 2 Exp

I'm using the Pivot table with 2 Dimensions and 2 Expression and dragged one to top level.I need Total for Selten expression to the extreme Right side.I don't need total for the date column(Ende).In presentation for the Total label I have given as Gemsa.

Hope you understand my requirement. Im getting the right sum from left to right

I need same column some at the extreme bottom for Seiten.Could experts pls help us to achieve the output...Need assistance

Pivot_2Exp.png

In-Advance

Thank you

1 Solution

Accepted Solutions

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Check the attached

Capture.PNG

10 Replies
anilnaidu13
Contributor

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Pls add ur suggestion

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Can you add a sample here?

anilnaidu13
Contributor

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Attached is the sample Qvw.Pls Add your inputs

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Where is the pivot table?

anilnaidu13
Contributor

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Is sheet 1 is  not visible to you ?

anilnaidu13
Contributor

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Sry my Mad.PFA

anilnaidu13
Contributor

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Sry .My Bad . Mistakenly added someother sample QVW.....Kindly see the attached  QVW with the Name Pivot_WithTotal.Qvw

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Sure

Re: Pivot table Total required for only one expression Partial sum not for 2 Exp

Check the attached

Capture.PNG

Community Browser