topic Re: Help in QlikView

Help

panipat1990 — Thu, 23 Jul 2015 07:08:01 GMT

Hi,

I am New In qlikview.....Please Help Me..

Suppose In Table one Field Contain Like Country US,U.S.A,AMERICA,USA......IWant to all Field Value In One Format Like USA.......So Help Me Which Function I used.....Please Send Me QVW File.....

Re: Help

ashfaq_haseeb — Thu, 23 Jul 2015 07:12:28 GMT

Hi,

Simple thing is to use inline function like illustrated below.

load * Inline

[

Country

U.S.A

AMERICA

USA

];

load * Inline

[

Country,Code

US,USA

U.S.A,USA

AMERICA,USA

USA,USA

];

Now use code in front end.

Regards

ASHFAQ

Re: Help

manojkulkarni — Thu, 23 Jul 2015 07:13:37 GMT

You can use ApplyMap function to do this clean up. Create one Mapping table for all possible value and use it.

Or same can be done using join as well.

refer. quick applymap example

Re: Help

tresB — Thu, 23 Jul 2015 07:15:36 GMT

use mapping like:

map1:

mapping load * inline [

Country,Code

US,USA

U.S.A,USA

AMERICA,USA

USA,USA

];

Final:

Load

ApplyMap ('map1', YourCountryField ) as Country
From <>;

Re: Help

MayilVahanan — Thu, 23 Jul 2015 07:19:39 GMT

Try like this

MapCountry:

Mapping Load * inline

[

CountryCode, County

USA, USA

America, USA

US, USA

];

load *, applymap('MapCountry', CountryCode, 'N/A') as CountryName inline

[

CountryCode

USA

America

];

Re: Help

nagarjuna_kotha — Thu, 23 Jul 2015 07:20:40 GMT

FYI....................

Re: Help

Thu, 23 Jul 2015 07:29:42 GMT

Or you can create a sample mapping table with country and codes like shown above, having one country column common. That will also help!

Re: Help

Thu, 23 Jul 2015 07:31:16 GMT

try this one load pick(match('US','U.S.A','AMERICA','USA'),'USA','USA','USA','USA') AS [Country Name], * inline [ US U.S.A AMERICA USA ];

Re: Help

sasiparupudi1 — Thu, 23 Jul 2015 13:44:04 GMT

Please see the attachment.

Hope this helps

//Have your mappings done in a mapping table

CountryMap:

Mapping load * Inline

[

Country,COuntry_Code

US,USA

U.S.A,USA

AMERICA,USA

USA,USA

IND,India

CHN,China

U.K,UK

Aruba (Netherlands),Netherlands

];

Data1:

load ApplyMap('CountryMap',Country,'N/A') as Country,Sales

Inline

[

Country,Sales

US,1000

U.S.A,10000

AMERICA,20000

USA,4000

IND,30000

CHN,5000

U.K,1000000

Aruba (Netherlands),20000

];

Re: Help

sasiparupudi1 — Thu, 23 Jul 2015 18:27:25 GMT

If you got your answer, please close this thread by marking the correct answer

Sasi