Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make BC9000 display as BC9000_ ?

Hi All

I like to add the under score on the Product Name., For example

C9000-H119 become C9000-H119_

CX1900-0320 become CX1900-0320_

My existing code now is below :-

     Product as [PART_NO_],

I imagine it should be some thing like this :-

     Product as [PART_NO_],

  Product&'_' as [PART_NO_],

But it does not work.

Paul

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Product&'_' as Product

View solution in original post

5 Replies
paulyeo11
Master
Master
Author

This is my QV doc.

datanibbler
Champion
Champion

Hi Paul,

say your fieldname (in the script) is > product_id <

=> Then, in the LOAD (script) you would go

LOAD

  ....

  ....

  product_id & '_' as product_ID

FROM ...

(so you would concatenate the actual contents of the field and an underscore)

HTH

Best regards,

DataNibbler

Anonymous
Not applicable

Try

Product&'-' as Part_No

MK_QSL
MVP
MVP

Product&'_' as Product

paulyeo11
Master
Master
Author

Hi All

Yes it work , thank.

Paul