Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Iamwilliamlo
Contributor
Contributor

concat 2 fields

Hi all,

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

Iamwilliamlo_0-1597729731400.png

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

2 Solutions

Accepted Solutions
tresesco
MVP
MVP

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

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

, unless you want to aggregate on values. 

View solution in original post

lironbaram
Partner - Master III
Partner - Master III

hi 
you don't need concat function

you can use 

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

View solution in original post

3 Replies
tresesco
MVP
MVP

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

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

, unless you want to aggregate on values. 

lironbaram
Partner - Master III
Partner - Master III

hi 
you don't need concat function

you can use 

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

Iamwilliamlo
Contributor
Contributor
Author

thanks for help. Its work!