Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
ronaldwang
Contributor III

label of subtotal in pivot table

in the pivot table, if we need to add up subtotal, the label will show total but not with the dimension name, is there any way to have dimension name added to the label automatically

1 Solution

Accepted Solutions
Highlighted

Re: label of subtotal in pivot table

If you want a SubTotal label with the value of a particular dimension included (like the Order Number, or Area name), the nyour best option seems to be to switch the Pivot table layout to Indent Mode. The dimension values will move closer to the subtotal lines.

See: Subtotal Label "Total" has to be change in Pivot table

View solution in original post

8 Replies
Highlighted

Re: label of subtotal in pivot table

Try to make one example and explain the visualization. I am sure, You will get it

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
ronaldwang
Contributor III

Re: label of subtotal in pivot table

Hi Anil, the visualizaiton is as below:

CaptureP.PNG

Highlighted

Re: label of subtotal in pivot table

May be enabling the Partial Sum option from presentation tab?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
madhumitha
Contributor

Re: label of subtotal in pivot table

Hello Ronald,

You can modify the name for Totals in the Presentation tab as below

Highlighted

Re: label of subtotal in pivot table

I was wondering whether we could include the current valiue of the Dimension field for which a subtotal was being calculated in the Label text. Unfortunately, it seems that the Pivot table object evaluates the expression only once, instead of for every occurrence of a subtotal in that particular column.

For example and using the columns from the OP, if you enable Partial Sums for Level 5 and Level 6, adding the following expression as Totals Label for Level 6 won't produce the expected outcome:

=[Level 5] & ' total'

will get you ' total' and nothing more.

So, Label for Totals accepts expressions that produce a fixed string for all occurrences. Until proven otherwise

Highlighted

Re: label of subtotal in pivot table

If you want a SubTotal label with the value of a particular dimension included (like the Order Number, or Area name), the nyour best option seems to be to switch the Pivot table layout to Indent Mode. The dimension values will move closer to the subtotal lines.

See: Subtotal Label "Total" has to be change in Pivot table

View solution in original post

Highlighted

Re: label of subtotal in pivot table

Attached

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
madhumitha
Contributor

Re: label of subtotal in pivot table

Hi Peter,

Your above expression works when we have a selection in the table.

Wondering how we can achieve it without selections made.