Qlik Community

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.

RegionBURecord 1Record 2Record 3Record 4BU
AsiaIndia1111India
China2222China
Japan3333Japan
Autralia4444Autralia
Thailand5555Thailand

Thank you in Advance !!

1 Solution

Accepted Solutions
MVP
MVP

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

Hi

Add an expression

= 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
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
MVP

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

Hi

Add an expression

= 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,

Sorry for my late reply,

Thank You so much Jonathan.

Regards

Nikhil

senpradip007
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).

Hope it will help you

Pradip

Not applicable

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

Dear Pradip,

Yes, That will help.

Thank You.

Regards

Nikhil

Community Browser