topic Re: Concat problem in App Development

Concat problem

gwmills_fiserv — Sat, 16 Nov 2024 07:00:15 GMT

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?

Re: Concat problem

ychkojima — Thu, 20 Dec 2018 01:00:22 GMT

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

Re: Concat problem

gwmills_fiserv — Thu, 20 Dec 2018 02:52:59 GMT

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

Re: Concat problem

RyCarm — Mon, 20 Jun 2022 14:14:26 GMT

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)