Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

6 Replies
swuehl
MVP
MVP

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
Author

Thank You so much It would really help me

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

jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

Hi,

Sorry for my late reply,

Thank You so much Jonathan.

Regards

Nikhil

senpradip007
Specialist III
Specialist III

Hi Nikhil,

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

Hope it will help you

Pradip

Not applicable
Author

Dear Pradip,

Yes, That will help.

Thank You.

Regards

Nikhil