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: 
gwmills_fiserv
Partner - Contributor II
Partner - Contributor II

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
ychkojima
Partner - Contributor
Partner - Contributor

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

View solution in original post

3 Replies
ychkojima
Partner - Contributor
Partner - Contributor

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

gwmills_fiserv
Partner - Contributor II
Partner - Contributor II
Author

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

RyCarm
Contributor II
Contributor II

What if there IS a need to use concat? For example, if you're trying to concatenate all the values in a field and use it in the calculated dimension (And receive the above error)