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: 
nesonica
Contributor III
Contributor III

Concatenate numbers not working

Hi guys,

I wanted to concatenate the columns D, N, and A. Unfortunately I get no results when concatenating with

=CONCAT([D],[N],[A])

CustomerDNA(expected)DNA
1122122
2221221
3311311

 

Can you guys help me? 🙂 

Labels (3)
1 Solution

Accepted Solutions
Shubham_Deshmukh
Specialist
Specialist

Use this :
=D&N&A

//Update : no use of '' in between.

View solution in original post

5 Replies
Shubham_Deshmukh
Specialist
Specialist

Use this :
=D&N&A

//Update : no use of '' in between.

d_petrov
Contributor III
Contributor III

You can do it in the script like: D & N & A AS Your_Column
vishsaggi
Champion III
Champion III

Did you try like

D&N&A
vishsaggi
Champion III
Champion III

BTW you should use & rather than comma for concat something lik

Concat(D&N&A, '')
or just
Concat(D&N&A)
nesonica
Contributor III
Contributor III
Author

That worked perfectly, thank you! 😄