rename 1 field from the dimension

[#1]

Hi guys!

I already used the pick and match function to rename values in my dimension.

But what do I do when I only want to rename 1 value.

As you can see in the attachment there is one field in english, I would like to rename this.

I used:

=(pick( WildMatch(reason_uitleg,'*Address uninhabited*'),'Onbewoond'))

But then I get only one bar called 'onbewoond' and all the rest is accumulated in one bar called '-'

How do I only rename one value and leave the rest unchanged?

Kind regards,

Katleen

[#2]

Hi,

The easiest way is to rename the value in the LOAD table.

You can use also in Chart Properties - tab Presentation - Limit Legend (Characters).

In Presentation Tab there a lot of function which you can use to fix this problem.

Regards,

Venelin

[Anonymous · Accepted solution]

=if ( WildMatch(reason_uitleg,'*Address uninhabited*') , 'Onbewoond' , reason_uitleg )

[#4]

Sorry,

I don't understand the question corectly at first time.

I think that your solution is correct, Bill Markham .

[#5]

I made a sample qvw, perhaps you can show me how it is possible?

Kind regards,

Katleen

[#6]

This works, thanks!

[rupaliqlik]

Add this in Dimension Tab->Add calculated Dimension

=if(reason_uitleg like '*Address uninhabited*','Onbewoond',reason_uitleg )

[sudeepkm]

you can use if else.

if(reason_uitleg='Address uninhabited','Onbewoond',reason_uitleg)