topic Rename content dimension in QlikView

Rename content dimension

Fri, 08 Aug 2014 06:56:49 GMT

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 — Fri, 08 Aug 2014 06:58:35 GMT

This can be done in set analysis.

Why don't you share some dummy data?

er_mohit — Fri, 08 Aug 2014 07:01:42 GMT

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 — Fri, 08 Aug 2014 07:08:24 GMT

Try this:

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

Thanks,

amit_saini — Fri, 08 Aug 2014 07:18:09 GMT

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

Fri, 08 Aug 2014 07:30:01 GMT

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

Fri, 08 Aug 2014 07:35:48 GMT

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 — Fri, 08 Aug 2014 07:44:00 GMT

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