Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

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

Re: How to make BC9000 display as BC9000_ ?

Product&'_' as Product

5 Replies
paulyeo11
Valued Contributor II

Re: How to make BC9000 display as BC9000_ ?

This is my QV doc.

datanibbler
Esteemed Contributor

Re: How to make BC9000 display as BC9000_ ?

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

jebamalai
Valued Contributor

Re: How to make BC9000 display as BC9000_ ?

Try

Product&'-' as Part_No

Re: How to make BC9000 display as BC9000_ ?

Product&'_' as Product

paulyeo11
Valued Contributor II

Re: How to make BC9000 display as BC9000_ ?

Hi All

Yes it work , thank.

Paul

Community Browser