topic Concatenate numbers not working in QlikView

Concatenate numbers not working

nesonica — Sat, 16 Nov 2024 04:14:54 GMT

Hi guys,

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

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

Can you guys help me? 🙂

Shubham_Deshmukh — Thu, 07 Mar 2019 13:16:15 GMT

Use this :
=D&N&A

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

d_petrov — Thu, 07 Mar 2019 13:11:02 GMT

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

vishsaggi — Thu, 07 Mar 2019 13:11:10 GMT

Did you try like

D&N&A

vishsaggi — Thu, 07 Mar 2019 13:12:46 GMT

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

Concat(D&N&A, '')
or just
Concat(D&N&A)

nesonica — Thu, 07 Mar 2019 13:30:14 GMT

That worked perfectly, thank you! 😄