Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi!
There should be no need to use Concat()
[Company]&'-'&[CENTER]&'-'&[GL Account]
Hi!
There should be no need to use Concat()
[Company]&'-'&[CENTER]&'-'&[GL Account]
Thank you. Perhaps I do not understand the use of the Concat feature in Qliksense.
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)