Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Label for Totals Expressions in Pivot Table

Hi All,

Please see the attached screenshot below for the pivot table in question.

error loading image

I'd like to add labels at each level instead of the 'Total' currently shown.

The total for the Account column should show the NetAssetGroup, likewise the total line under the Activity column should show the Account group. I've tried various formula, only succeeding when selections are made.

The text should display when no selections are made.

Thanks in advance.

19 Replies
agigliotti
Partner - Champion
Partner - Champion

Hello All,

Currently I'm using the latest version 11.20.11705  and the problem has not been fixed yet.

When we can expect to be fixed ?

agigliotti
Partner - Champion
Partner - Champion

any good news about the issue???

agigliotti
Partner - Champion
Partner - Champion

Hi John,

any good news from QlikTeck about this missing functionality ?

Not applicable
Author

You Can use the Indent mode with a text concatenated with the dimension to get close to the requirement.

Label 1.jpgLabel 2.jpg

tyagishaila
Specialist
Specialist

Hi Rupas,

Could you please attach .qvw for your solution.

Thanks,

Shaila

Not applicable
Author

Hi Shaila,

Do you still need thee qvw or did you figure out how this is done?

Regards,

Rufus Lopes

tyagishaila
Specialist
Specialist

Sorry for late reply

I was not active on community from last 2 3 weeks,

I have done it

Thanks for All

regards,

Shaila

Not applicable
Author

Could you please close the thread by selecting the correct answer or post the correct solution?

tyagishaila
Specialist
Specialist

Hi Rupas,

Here is no option available for Helpful/Correct Answer.

I am able to click on Like only.

Thanks,

psankepalli
Partner - Creator III
Partner - Creator III

Hi Saila,

I am looking for the same answer, can you please update the solution and mark it as answer. so that everyone can find the answer

Thanks

PS