Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
PFA
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!
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.
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.
Resolved! Thanks All!