Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

Replacing fields names

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

countrysalebudget
Indai 10
india5 
usa42
uk13


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

countrysalebudget
india510
usa42
uk13

 

can anyone help me,thanks in advance.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

6 Replies
Vengatesh
Partner - Creator
Partner - Creator

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

You Know What To Do.
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Use ApplyMap for the country field.

venkat1
Creator II
Creator II
Author

 it was misspelled in data.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Jesh19
Creator II
Creator II

You can also try the below one

In your modelling, Please do as follows

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

Thanks,

Jesh