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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)