topic Re: Subtotal expression in pivot table in QlikView

Subtotal expression in pivot table

Anonymous — Thu, 10 Dec 2015 10:09:13 GMT

Hi all,

I need to create a table with subtotals as count of rows in table for each dimension value. I believe i can use 'Label for totals' on Presentation tab, but i can only achieve count of rows over whole table, not grouped by dim1. In the example bellow there should be Count 5 and Count 3, not Count 8 in both rows.

Could you please suggest me any solution?

Many thanks.

Re: Subtotal expression in pivot table

sunny_talwar — Thu, 10 Dec 2015 11:35:12 GMT

See if this helps:

=If(Dimensionality() = 1, Count(Aggr(Sum(value), dim1, dim2)), Sum(value))

Re: Subtotal expression in pivot table

Anonymous — Thu, 10 Dec 2015 12:00:38 GMT

Thank you Sunny for your valuable advice, but it is not exactly what i would like to get. In picture bellow I noted which values im not satisfied with.

Re: Subtotal expression in pivot table

Kushal_Chawda — Thu, 10 Dec 2015 12:03:38 GMT

Hi,

For this you need to use Dimensionality() function, but this function will not be evaluated in Label. It will work only in expression. So you will not be able to display Count 5 and Count 3

Re: Subtotal expression in pivot table

Anonymous — Thu, 10 Dec 2015 12:04:54 GMT

I think he is talking about Count 8 label, he want to replace it Count 5 in case of 5 dim and Count 3 in case of 3 dim...

I do not think this would be possible becoz Label of Total would be common for whole table.

Re: Subtotal expression in pivot table

Anonymous — Thu, 10 Dec 2015 12:15:08 GMT

Ok guys, thanks for your effort, i accept that this should be solved within expression, im going inspect dimensionality() usage.