Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Partner
Partner

Concat problem

I am trying to combine 3 fields in my database:    Company, CENTER, GL Account (spelled in that manner) into a single field in a chart that would read: Company-Center-GL Account.    For  example    001-48-123456

I am using the following expression:=Concat([Company]&'-'&[CENTER]&'-'&[GL Account])

When I exit the expression editor, I receive an error Invalid Dimension.

Any suggestions?

Labels (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Concat problem

Hi!
There should be no need to use Concat()
[Company]&'-'&[CENTER]&'-'&[GL Account]

2 Replies
Partner
Partner

Re: Concat problem

Hi!
There should be no need to use Concat()
[Company]&'-'&[CENTER]&'-'&[GL Account]

Highlighted
Partner
Partner

Re: Concat problem

Thank you.    Perhaps I do not understand the use of the Concat feature in Qliksense.