Replacing fields names

[venkat1]

Hello Friends,
I am having County.Budget,sales fields and values are shown below,

country	sale	budget
Indai		10
india	5
usa	4	2
uk	1	3

After making a pivot chart i am getting the result like as shown above,but in my case i want to show like as below

country	sale	budget
india	5	10
usa	4	2
uk	1	3

can anyone help me,thanks in advance.

[Vengatesh]

What is the expression you are using? and INDIA is misspelled by mistake or that is how it is in data? 

[MindaugasBacius]

Use ApplyMap for the country field.

[venkat1]

 it was misspelled in data.

[rwunderlich · Accepted solution]

At the beginning of your script add:

CountryMap:
LOAD * Inline [
from, to
Indai, india
];
MAP Field Country Using CountryMap;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Brett_Bleess]

Venkat, did Rob's post do the trick for you?  If so, please be sure you return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and let other Community Members know that worked.  If you have trouble marking things, you can leave a new comment confirming that did work, and I can circle back and mark it for you.  If you still need help, leave us an update.

Here is a Design Blog on Mapping too that might come in handy, in addition to what Rob gave you already, further explanation on usage:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

Regards,
Brett

[Jesh19]

You can also try the below one

In your modelling, Please do as follows

If(country='indai','India',Country) as Country

Thanks,

Jesh