# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

## Can we have the same dimension twice in the object ?

Hi All,

Once again I need the assistance from you all.

I am preparing the dashboard and need to have the similar dimension as the end.

For example in the below table I have mentioned the BU twice. Actually we have the lengthy report for several branches therefore it is difficult to look at the indiviudal values and that is why we  want to have BU twice so that the viewer can have ease while looking at the figures.

 Region BU Record 1 Record 2 Record 3 Record 4 BU Asia India 1 1 1 1 India China 2 2 2 2 China Japan 3 3 3 3 Japan Autralia 4 4 4 4 Autralia Thailand 5 5 5 5 Thailand

1 Solution

Accepted Solutions
MVP

## Re: Can we have the same dimension twice in the object ?

Hi

= Only(BU)

That should do the trick (Oh, and set 'No Total' to avoid the dash in the total line)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
6 Replies
MVP

## Re: Can we have the same dimension twice in the object ?

You can use BU twice as dimension (need to input BU once as calculated dimension), or just use BU once as dimension and then as expression (I would prefer latter).

Not applicable

## Re: Can we have the same dimension twice in the object ?

Thank You so much It would really help me

but can I also give the same format setting as dimension in the report ?

MVP

## Re: Can we have the same dimension twice in the object ?

Hi

= Only(BU)

That should do the trick (Oh, and set 'No Total' to avoid the dash in the total line)

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

## Re: Can we have the same dimension twice in the object ?

Hi,

Thank You so much Jonathan.

Regards

Nikhil

Valued Contributor III

## Re: Can we have the same dimension twice in the object ?

Hi Nikhil,

You can just use BU once as dimension and then as expression Only(BU).

Not applicable