Retrieving SubTotals from a qHyperCube in DATA_MODE_PIVOT
We are in the process of developing an extension object similar to a classic pivot table utilizing Hypercube's qMode property called DATA_MODE_PIVOT (Pivot Table data representation).
When the pivot table is expanded, we still need to display the sub totals (Think of a classic QlikView Pivottable with subtotals), but we have no idea where to get the aggregated data from.
On the Straight Table there's the qGrandTotalRow property which returns the total row for the whole column - we need the same but for the SubTotals which ideally gets updated on the ExpandLeft/ExpandTop method.
Re: Retrieving SubTotals from a qHyperCube in DATA_MODE_PIVOT
I need your help! Trying to get the qGrandTotalRow... Did you find a solution for that? I have checked the help and qlick comunity but not everibody use the Table Pivot extension with multiples dimensions.
I create a total row but in some case like sum of % it doesn´t well. Can you help me how to show the qGrandTotalRow?