Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nesonica
New 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
Valued Contributor

Re: Concatenate numbers not working

Use this :
=D&N&A

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

5 Replies
Shubham_Deshmukh
Valued Contributor

Re: Concatenate numbers not working

Use this :
=D&N&A

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

d_petrov
New Contributor III

Re: Concatenate numbers not working

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

Re: Concatenate numbers not working

Did you try like

D&N&A
vishsaggi
Esteemed Contributor III

Re: Concatenate numbers not working

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

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

Re: Concatenate numbers not working

That worked perfectly, thank you! 😄