Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

bumin
Contributor II

How to show the name of the dimension in subtotal field?

Hi,

I want to show the name of the dimension in the subtotal line

GroupcolourSum (value)
ablue200
red100
Subtotal  a300
byellow500
Subtotal b500
cblack300
magenta240
Subtotal c540
Total1340

is there any way to do it?

thanks

bumin

3 Replies
hallquist_nate
Contributor III

How to show the name of the dimension in subtotal field?

I have been working on this for you, and have not come up with an answer.  However, I did find this previous post:  http://community.qlik.com/ideas/2386

Also, if you have a selection, =GetFieldSelections(FieldName) will produce the desired effect, but you have to have a selection made.  You put this formula in the Presentation tab of the Chart properties, in the Labels for Totals formula box.  You use the field name that is one level above the desired totals column.  So, if you have Regions, then state in a pivot table, you put this formula in the State dimension, and it will populate the Region, when a region is selected.

It isn't a real great solution, but maybe this will inspire someone else to post a better, or correct solution, maybe something with Set Analysis?

mountaindude
Contributor III

Re: How to show the name of the dimension in subtotal field?

I am too looking for a way to do this, did you ever find a solution?

thanks,

Göran

MVP
MVP

Re: How to show the name of the dimension in subtotal field?

Hi

Have you tried playing around with Indent mode (on the Style tab)? It will do most of what you need if you set up the dimensions vertical and horizontal alignment correctly.

One caution - if you need to change the partial totals, you will need to turn off indent mode, change the partial totals and re-enable partial totals, because for some strange reason, the partial totals options are grayed out when indent mode is on.

HTH
Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser