Rename content dimension

[#1]

I have a question for you guys.

It seems impossible to me, but perhaps it is possible in qlikview.

For example I have a field named status.

this can be (open, solved, cancelled).

Can I rename the content?

open = stil in progress

...

Is this possible?

Kind regards,

Katleen

[Anonymous]

This can be done in set analysis.

Why don't you share some dummy data?

[er_mohit · Accepted solution]

yeah on front end you can use pick match concept like your field Status

Pick(Match(status,'open', 'solved', 'cancelled'),'stil in progress','xyz','abc')

hope it helps

[amit_saini]

Try this:

pick( WildMatch(status,'*open*','*solved*','*cancelled*'),'stil in progress','xyz','abc')

Thanks,

AS

[amit_saini]

Also you can try this way also:

LOAD * INLINE [

status , status_new

open,stil in progress

solved,xyz

cancelled,abc

];

See the attachment.

Thanks,
AS

[#6]

Can you explain what tre 'xyz' and 'abc' is for?

[#7]

I added a sample qvw with the data that I am trying to rename.

If you guys would take a look at it that would be great!

[er_mohit]

hi i just write it for another name if you want for rest of field data if not then just write the actual name where i write either abc or xyz