cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
Françoise
Level V

Value labels

hi,

 

I try to replace "0,00%" by empty space via JSL inside the column "RmG"

I wrote this script:

 

Column( dt, "RmG" ) << Value Labels( {"0%"}, {""} );
Column( dt, "RmG" ) << Use Value Labels( 1 );

 

 

but it doesn't work.

 

Thanks for your help.

 

best regards

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Value labels

Your syntax is incorrect for setting a Value Labels.  If the RmG column is character, the label should be set with:

Column( dt, "RmG" ) << Value Labels( {"0%" = " "} );

However, I suspect the RmG column might be a numeric column, and if so, the label should be set with:

Column( dt, "RmG" ) << Value Labels( { 0 = " "} );
Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Value labels

Your syntax is incorrect for setting a Value Labels.  If the RmG column is character, the label should be set with:

Column( dt, "RmG" ) << Value Labels( {"0%" = " "} );

However, I suspect the RmG column might be a numeric column, and if so, the label should be set with:

Column( dt, "RmG" ) << Value Labels( { 0 = " "} );
Jim
Françoise
Level V

Re: Value labels

Hi, 

 

It doesn't work and I don't understand why.

 

best regards

Jeff_Perkinson
Community Manager Community Manager

Re: Value labels

Can you give some more details about how it doesn't work?

 

Is the Value Label property applied but you have values that are not getting labeled? If so, we'll need some details about the column, like it's data type and the values in it? Posting a small sample that demonstrates the problem would be best.

 

Or, is the Value Label property not applied at all from your JSL? If so, is there any error message in the Log Window?

-Jeff