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

.

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Try to AGGR your expression

SUM(

AGGR(

     copypasteyourexpressionhere,

     Dim1,Dim2,Dim3  // All of your dimentions

)

)

View solution in original post

22 Replies
Highlighted
Specialist II
Specialist II

Do you use a calculated dimension? This might be the reason...

Highlighted
Creator III
Creator III

Dear Leah,

Please post sample Application for better understanding

Regards

Kiran Rode

Highlighted
Employee
Employee

Pivot table does not have this option, only straight table. This is how it is

Highlighted
Partner
Partner

Hi Jackson,

The Pivot table "Total mode" option not allowed. So go to Presentation Tab -> There you will find "Subtotals". subtotal we can manage there.

Highlighted
Not applicable

hey Jackson,

     in pivot table you will never see that "Total Mode box" enabled . it is always disabled.

try taking new pivot table with sample expression and you will always find as disabled.

Highlighted
Employee
Employee

Partial sums into pivot table are configured at "Presentation" tab

Highlighted
Creator
Creator

As I stated in the initial query, I have already selected the 'partial sum' indicators in the presentation tab.  I just wondered if the totals mode being greyed out contributed to the lack of totals showing on the chart. I guess not.

My next step is to rule out an 'odd' expression.

This is my pivot table:

pivot.jpg

I want to show totals (partial sums) under each 'Prod Grp No'.

The expressions are as follows (in order):

1.

exp1.jpg

2.

exp2.jpg

3.

exp3.jpg

4.

exp4.jpg

As you can tell from the expressions, I only want to show products with a margin over 40%, any under 40% are replaced with null.

This is my presentation tab settings:

presentation tab.jpg

I can't upload the file as I don't have authority to share this company data on a public forum.

Can anyone see any glaring reason why the partial sums aren't showing?  Am I asking too much from the pivot table?

Thanks again for your time and help.

Leah

.


Highlighted
Creator
Creator

No, none of the dimensions are calculated, I've just added more info.

Thanks for your time.

Highlighted

Tick the Partial Sums option on each dimension you want to be summed.

Ticking partial sums on Prod Grp No will just add an overall total.

Tick the partial sums option for ProductDesc as well.