Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sum Formula Pivot Table

Trying to create a pivot table with 3 functions: Quarter, Competitor and Segment.

Trying to display data as Segment>Competitor Quarter Wise.

Expressions: Total Sales, Market Share.

The table is not showing values as per different segment. Its showing the total amount. What formula should i use that the values are shown as per segments.    

2 Replies
sudeepkm
Valued Contributor III

Re: Sum Formula Pivot Table

Have you used partial sums options in the Chart properties? Once enabled this options will show you the segment wise sum when you expand the Pivot table nodes.

Not applicable

Re: Sum Formula Pivot Table

Hi Gaurang,

Could you please explain what ouput exactly u want ?

if possible post sample QVW

regards

Harshal

Community Browser