Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
wanyunyang
Contributor II

Renaming

Hi guys,

My data have a column called Activity, the values are Merchandising, Sales, Marketing.

Now I create a pivot table with Activity as pivot table columns:

Capture.PNG

I want to rename the values as MKT, Merch, Sales. What should I do?

Thanks in advance!

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Renaming

May be this as dimension instead of Activity, not tested though -

Aggr(Pick(Match(Activity,'Marketing','Merchandizing','Sales'),'MKT','Merch','Sales'),Activity)

View solution in original post

2 Replies
Digvijay_Singh
Honored Contributor III

Re: Renaming

May be this as dimension instead of Activity, not tested though -

Aggr(Pick(Match(Activity,'Marketing','Merchandizing','Sales'),'MKT','Merch','Sales'),Activity)

View solution in original post

rittermd
Honored Contributor

Re: Renaming

Can you rename them in your load script?  If want those values to be permanent that is what I would do.  Then you don't have to try to change them on every chart that you use them on.