Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Problem with headers of totals in pivot tables

Hi all!!

I have a problem with headers of totals in pivot tables, I need that the totals column description has the content as the previous dimension (total + dimension name,red letters in the image), something like this:

2014-07-29 16_42_10-Presentación1 - PowerPoint.png

I've tried playing with the value of the previous dimensions and te column() function... but does not work in pivot tables. Can anyone help me?.

Thanks for all!!

6 Replies
michael_maeuser
Contributor III

Re: Problem with headers of totals in pivot tables

see attached

michael_maeuser
Contributor III

Re: Problem with headers of totals in pivot tables

in your case instead of CustomerID, write ='Total ' & dimensionname

Not applicable

Re: Problem with headers of totals in pivot tables

Thanks for your reply, but don't works, not recognize the dimension name and paint '-':

2014-07-29 16_42_10-Presentación1 - PowerPoint.png

Not applicable

Re: Problem with headers of totals in pivot tables

Any more idea??

michael_maeuser
Contributor III

Re: Problem with headers of totals in pivot tables

i thought it worked with just the field name, but that only helps (of course, after rethinking ) if you have selected a dimension value. i guess there is no solution, i rememeber i had the issue a year ago and neither found a solution for this

Not applicable

Re: Problem with headers of totals in pivot tables

I think the same, thanks for your help Michael.

Regards.

Community Browser