topic concat 2 fields in QlikView

concat 2 fields

Iamwilliamlo — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i had a straight table which i tried to use concat function to merge first two columns.

i put =Concat([FltDate WeekYear]&''&[FltDate WeekSun]) in the expression but comes out with error. i want to display 202032. apprec your help.

tresB — Tue, 18 Aug 2020 06:02:12 GMT

Perhaps you don't need concat(), but just:

[FltDate WeekYear]&''&[FltDate WeekSun]

, unless you want to aggregate on values.

lironbaram — Tue, 18 Aug 2020 06:09:13 GMT

hi
you don't need concat function

you can use

[FltDate WeekYear]&''&[FltDate WeekSun]

Iamwilliamlo — Tue, 18 Aug 2020 06:27:21 GMT

thanks for help. Its work!