# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## Use Dimension element as Total label ?

Below Niveau3 elements sums up to 'Resultat' in Niveau4.

I have renamed Total label to blank, and right aligned Niveau4.

Is it possible to combine Total cell with Niveau3 'Resultat' like I have done below in excel?

Kind regards

Jerrik Walløe

Coop Denmark

1 Solution

Accepted Solutions
Contributor III

## Re: Use Dimension element as Total label ?

I think got it to do what you need

Go to the Style tab and check the indent mode like this

13 Replies

## Re: Use Dimension element as Total label ?

No, that's not possible. The total label can only have one value for the entire dimension column. But you can create a new field in the script and use that as dimension. See here for an example: Custom Labels in Pivot Table

talk is cheap, supply exceeds demand
Not applicable

## Re: Use Dimension element as Total label ?

I had a look at the linked solution. It may work in small scale, but my hierachy is big and not static.

I hope for other solutions. Total labels can be filled with Dimension element text, in others BI tools. So perhaps QV also.

Contributor III

## Re: Use Dimension element as Total label ?

You can use dimensionality() to redefine the Totals in your pivot table.

Contributor III

## Re: Re: Use Dimension element as Total label ?

I created an example. Take a look.

Not applicable

## Re: Use Dimension element as Total label ?

Label for grandtotal is changed, but could the label for subtotal be changed?

For Dim2 I tried to set [Label for total] to [=Before(DIM1)] but then just '-' are displayed. Same for [=Only(Dim1)]

Contributor III

## Re: Use Dimension element as Total label ?

You can change the label for subtotals by using

If (dimensionality() = 1, .... Notice that the dimensionality for normal cell is =2 for subtotals is =1 and for grand total is =0. Using that you can redefine what is shown in any of the cells.

Not applicable

## Re: Use Dimension element as Total label ?

=If (dimensionality() =1 , DIM1) dont work. Nor =If (dimensionality() =1 , only(DIM1))

Contributor III

## Re: Use Dimension element as Total label ?

Where are you using this in the total label or in the expression?

Can you explain in more detail what you are trying to do so I can try to help.

Contributor III

## Re: Use Dimension element as Total label ?

Is that what you want?