topic Subtotals choice Pivot Table in QlikView

Subtotals choice Pivot Table

jaymerry — Wed, 13 Apr 2011 12:57:39 GMT

Hello,

I need to select on which columns (axis) I need to see Subtotals in a Pivot Table.

Can we activate / desactivate subtotals for a Pivot Table with a button ?

Do you think that this kind of functionnality is possible ?

Thank you for your help,

Regards,

Jaymerry

Miguel_Angel_Baeyens — Wed, 13 Apr 2011 13:30:16 GMT

Hello Jaymerry,

If you mean you want to see subtotals from some of your expressions but not all of them, use the Dimensionality() function:

If(Dimensionality() = 0, Sum(Value), '')

Hope that helps.

jaymerry — Thu, 14 Apr 2011 14:03:56 GMT

Hello Miguel,

Thanks for your answer.

No, what I need is to select on which dimensions subtotals appear.

Thanks for your hep,

Best regards,

Jaymerry

jaymerry — Fri, 15 Apr 2011 09:52:44 GMT

Hello all,

Any ideas to manage subtotals with macros ?

Thanks for your help,

Jaymerry

Miguel_Angel_Baeyens — Fri, 15 Apr 2011 09:57:48 GMT

Hello Jaymerry,

Check this post. You will likely need to check the API Guide.qvw file in your QlikView folder\Documentation for further options.

Hope that helps.

jaymerry — Thu, 21 Apr 2011 16:32:41 GMT

Thanks for your help Miguel.

Best Regards,

Jaymerry