Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
Hello all,
Any ideas to manage subtotals with macros ?
Thanks for your help,
Jaymerry
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.
Thanks for your help Miguel.
Best Regards,
Jaymerry