topic Re: Show Partial Sums doesn't show correctly in QlikView

Show Partial Sums doesn't show correctly

Thu, 26 Sep 2013 12:38:13 GMT

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?

Re: Show Partial Sums doesn't show correctly

nizamsha — Thu, 26 Sep 2013 12:57:41 GMT

PFA

Re: Show Partial Sums doesn't show correctly

Thu, 26 Sep 2013 13:31:24 GMT

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!

Re: Show Partial Sums doesn't show correctly

christian77 — Thu, 26 Sep 2013 13:49:54 GMT

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.

Re: Show Partial Sums doesn't show correctly

rodrigo_damas — Thu, 26 Sep 2013 14:15:42 GMT

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.

Re: Show Partial Sums doesn't show correctly

Thu, 26 Sep 2013 14:26:51 GMT

Resolved! Thanks All!