Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Employee
Employee

Try to AGGR your expression

SUM(

AGGR(

     copypasteyourexpressionhere,

     Dim1,Dim2,Dim3  // All of your dimentions

)

)

View solution in original post

22 Replies
Specialist II
Specialist II

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

Creator III
Creator III

Dear Leah,

Please post sample Application for better understanding

Regards

Kiran Rode

Employee
Employee

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

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.

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.

Employee
Employee

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

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

.


Creator
Creator

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

Thanks for your time.

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.