Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Partner
Partner

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.
Highlighted
Specialist III
Specialist III

Use ApplyMap for the country field.

Highlighted
Creator II
Creator II

 it was misspelled in data.

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Digital Support
Digital Support

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.
Highlighted
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