topic Re: Replacing fields names in QlikView

Replacing fields names

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Replacing fields names

Vengatesh — Fri, 22 Nov 2019 11:45:12 GMT

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

Re: Replacing fields names

MindaugasBacius — Fri, 22 Nov 2019 13:37:48 GMT

Use ApplyMap for the country field.

Re: Replacing fields names

venkat1 — Mon, 25 Nov 2019 05:34:34 GMT

it was misspelled in data.

Re: Replacing fields names

rwunderlich — Thu, 28 Nov 2019 18:16:57 GMT

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

Re: Replacing fields names

Brett_Bleess — Thu, 05 Dec 2019 19:47:45 GMT

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

Re: Replacing fields names

Jesh19 — Fri, 06 Dec 2019 06:27:55 GMT

You can also try the below one

In your modelling, Please do as follows

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

Thanks,

Jesh