topic Concat two number fields in QlikView

Concat two number fields

Tue, 17 Feb 2015 06:41:46 GMT

I have the following table:

Order Number	Line Number
10000	500
20000	750
30000	800
RE-10356	1000

I want to merge the two fields and have the following output as Order-Line numbet:

10000-500

20000-750

30000-800

RE-10356-1000

I am able to concatenate only two text formats, but not number formats.

Can anyone help me please with a Qlikview file/.

Re: Concat two number fields

senpradip007 — Tue, 17 Feb 2015 06:45:02 GMT

Try to use like [Order Number] & '-' & [Line Number] As [New Field]

Re: Concat two number fields

Tue, 17 Feb 2015 06:46:05 GMT

it is not working.

it works for date and text formats,.

Re: Concat two number fields

senpradip007 — Tue, 17 Feb 2015 06:49:13 GMT

In my app its working fine. Still try like Text([Order Number]) & '-' & Text([Line Number]) As [New Field].

Re: Concat two number fields

Tue, 17 Feb 2015 06:53:32 GMT

No. this is also not working.

Re: Concat two number fields

jagan — Tue, 17 Feb 2015 07:01:54 GMT

Hi,

Try like this

LOAD

Text([Order Number] & '-' & [Line Number]) As [New Field]

FROM DataSource;

Regards,

Jagan.

Re: Concat two number fields

senpradip007 — Tue, 17 Feb 2015 07:09:17 GMT

Could you please upload sample app or your script?

Re: Concat two number fields

senpradip007 — Tue, 17 Feb 2015 07:11:34 GMT

Have tested with RowNo() & '-' & (RowNo()-1) AS Test2 expressions. Outcome of this expression is like

1-0

2-1

3-2

...

N-(N-1)

Re: Concat two number fields

jonathandienst — Tue, 17 Feb 2015 07:42:28 GMT

Pradip Sen's answer is correct for your question. If it is not working for you, please provide details of exactly what is wrong, including the output you are getting from the example data in your post. Otherwise we are just guessing...

Jonathan