Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

cocnatenate fields?

i want concatenate fields  using chr(39)

how like

field1 &chr(39) &filed2  like this how ?

4 Replies
its_anandrjs
Champion III
Champion III

Hi,

Expression is correct try this in any list box expression or in load script

Ex:-

=Year &chr(39)&Month


Or


Load

Year &chr(39)&Month  as New

From Source;


chr(39) returns ( ' ) symbol



Regards

Anand



Anonymous
Not applicable
Author

Yup, that is the way to do it.

Is there any specific problem you are facing ?

its_anandrjs
Champion III
Champion III

For better you can use chr(45) this returns ( - )


Load

field1 &chr(45)& field2  as New

From Source;



Regards

Anand

Not applicable
Author

I prefer pipe (chr124) myself , dash I find in data to often