Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Partial Sums doesn't show correctly

Hi,

I tried to have sub total for each AssetGroup however I have only got EQ with the total displayed correctly but missing the rest of them. Please can anyone suggest what went wrong? And how to fix?

Capture1.JPG.jpg

1 Solution

Accepted Solutions
rodrigo_damas
Partner - Contributor II
Partner - Contributor II

In both of your expressions, change "Only()" for "Sum()", because with only the partial sum get lost, and just show the partial sum for the assetgroup that have just one currency.

View solution in original post

5 Replies
nizamsha
Specialist II
Specialist II

PFA

Not applicable
Author

Hi Nizam,

I have personal edition of qlikview and am can't open your attachment. Any chance you can briefly tell what you have done to fix it?

Many thanks!

christian77
Partner - Specialist
Partner - Specialist

Hi:

In a pivot table the total cell is the Expression Total. if you want to control totals in a pivot table, use the function Dimensionality(). If you have a pivoted dimension you need also Secondarydimensionality()

In you table, set an expression Dimensionality() & ' - ' &Secondarydimensionality(). See what happens. Collapse and expand your dimensions. You have a map of dimensionalities. Now play with it.

If (dimensionality()=0, place you total expression, place your regular expresion)

good luck.

rodrigo_damas
Partner - Contributor II
Partner - Contributor II

In both of your expressions, change "Only()" for "Sum()", because with only the partial sum get lost, and just show the partial sum for the assetgroup that have just one currency.

Not applicable
Author

Resolved! Thanks All!