Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pra_kale
Creator III
Creator III

Straight Table chart..calculated Dimension

Hi,

I have created one straight table with 4 dimensions. My requirement is that I want one another additional dimension which is concatenate of this 4 dimensions. Also I want to give the name to that dimension.

I have tried it by '$' between two columns, but it is not working as I can not give a name to the newly added dimension also I want space between two dimensions names.

Can any one help me in this.

Thanks in Advance.

4 Replies
ramoncova06
Partner - Specialist III
Partner - Specialist III

have you tried using '&' ?

the syntax would be like

dimension1&dimension2&dimension3&dimension4

pra_kale
Creator III
Creator III
Author

Thanks for your reply.

Yes, I have tried it same way, but how to give name to the added dimension as I am getting that formula only at that place as a dimension name...also I want to give space between them. Whether this Two things are possible?

Not applicable

Type the name you want in the label section. Also if you want a space then it should be, name1& ' '&name2&'  '&name3&' '&name4. Thanks

Untitled.png

ramoncova06
Partner - Specialist III
Partner - Specialist III

as Srukmana mentioned you need to add a label for any calculated dimension otherwise the label will show the expression being used