Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Total Mode 'greyed out' - no partial sums showing

I am trying to show partial sums on my pivot table, I normally have no problems, so can't understand what why today I'm having difficulties!

I have selected the 'partial sum' on the relevant expressions in the presentation tab, but no total rows appear.

I noticed in the expressions tab the Totals Mode box is completely greyed out ....for all the expressions (see attached screen shot).

Can anyone point in the direction of enabling the totals?

Many thanks

.

22 Replies
Highlighted
Employee
Employee

Tick "Show Partial Sums" to each dimension you want

Highlighted
Creator
Creator

Partial sums is ticked on every dimension already.

Does anyone have any other suggestion?

Thanks

.

Highlighted

Is Indent Mode ticked on the Style tab, this can change functionality with Pivot table properties.

Highlighted
Employee
Employee

Maybe your expression is not returning subtotals.

Please add a fixed expression like 1 and check if it shows

Highlighted
Creator
Creator

I gave that a try Colin, and hoped for a miracle ....it didn't happen!  

I ticked 'indent mode' and then the chart turned into a hideous mess.   I can see what it was trying to do, but wasn't what I needed for this.

I've not used that funtionality before, but now I know what it does.

Highlighted
Creator
Creator

I added the new expression, as you suggested, and the chart listed all products (regardless of the 40% margin restriction), along with the totals at the bottom of each product group.

I guess the way I've manipulated the expressions to filter out the lower performing products is affecting the calculation process of the total rows.

I now know that the partial sums are working, they are just not compatible with my expressions.

Thanks for your help.

Highlighted
Creator
Creator

Leah,

You need to check "Show Partial Sums" for each Dimension.  Each level that you check shows the aggregate subtotal for that dimension.  Right now you have partial sums checked for "Prod Grp No" only.  Since that is the highest level, at the moment, the pivot chart will only display a grand total of everything.  If you want subtotals for each "Prod Grp No", you need to select the dimension that is one level below, which is "Prod Grp Desc".

I understand how the Presentation tab is confusing.  If you notice, there is a border around the top section labeled "Dimensions and Expressions."  Everything within that border applies only to the currently selected dimension or expression.  Everything in the below section, which is unlabeled, applies to the entire chart.

I hope this helps.

Highlighted
Employee
Employee

Try to AGGR your expression

SUM(

AGGR(

     copypasteyourexpressionhere,

     Dim1,Dim2,Dim3  // All of your dimentions

)

)

View solution in original post

Highlighted
Not applicable

Hi Leah,

I am facing the same problem as yours. Is your problem solved? To resolve this problem I changed my expression using sum(Aggr(Expression),Dim1,Dim2,Dim3.....)) and I achieved my Output, But the chart becomes very heavy as loading time increased a lot because I am using 15 Dimensions and 44 Expressions. Do you have any solution for such kind of problem? Please suggest me any solution to come out of it.

Thanks.

Regards,

Yojas

Highlighted
Not applicable

Hi

Instead Try to aggregate it in the scripting rather than IN the chart

Regards