topic Re: Name totals in Pivottable in QlikView

Name totals in Pivottable

francisvandergr — Wed, 03 Jun 2015 08:03:12 GMT

I wanna change the name of the totals in a pivot table. Every total must have another name.

I work with partial sum.

I attached an example.

Re: Name totals in Pivottable

r_wroblewski — Wed, 03 Jun 2015 08:20:31 GMT

Hi Francis,

you can use

Chart Properties -> Presentation "Label for Totals" to change Name of different SubTotals.

1) Select the dimension which total you want to rename

2) Fill in new label or expression

Regards,

Ronny

Re: Name totals in Pivottable

Wed, 03 Jun 2015 08:24:41 GMT

Hi,

I would also recommend that using a variable to store the label, making it easy to change the label of multiple objects. It would also make it possible to incorporate multi language support.

Good luck!

Re: Name totals in Pivottable

jonathandienst — Wed, 03 Jun 2015 08:24:53 GMT

I am afraid that what you require is not possible without a complex workaround. It seems that the Total labels are not calculated per row but only once for the table

I saw a post here which described one such workaround, but I did not bookmark it. I suggest that you search the forum for a solution to your problem.

Re: Name totals in Pivottable

r_wroblewski — Wed, 03 Jun 2015 08:29:30 GMT

I'm not sure if this is the post Jonathan mentioned but I think this could help you.

Re: Showing Dynamic "Total Label"

Regards,

Ronny