Question about loading data

[Anonymous]

Hello all,

I am currently working on a Qlik visualization that utilizes about 800 rows of data regarding shipments to African countries. I am planning on creating a pie chart to show the different ratios. However, my other graphs in the dashboard have countries such as Sierra Leone and Guinea written completely whereas this new Excel data sheet with the 800 rows has them labeled "sl" and "gn" in each individual. As it would be both extraneous and tedious to go row-by-row changing the names of each country, I was wondering if there was any easier way to do this. I will attach a picture below of my current dashboard for more insight. I appreciate any help and thanks again!

Sincerely,

Munna

[Anonymous]

Hello,

I tried that and I still have several other errors showing up. Thank for your continued assistance.

[dberkesacn]

wow sorry put a last one at the and before AS

If(WildMatch(Country,'sl*'),'Sierra Leone',

      If( WildMatch(Country,'gn*'),'Guinea','Liberia'))  as ItWillWork,

[Anonymous]

no worries, I appreciate all the help. I'm learning a lot. However, I am still receiving errors after these statements.

[aarkay29 · Accepted solution]

[TOTAL SHIPMENTS]:

LOAD [Shipment Quantity In BUM],

  If(WildMatch(Country,'sl*'),'Sierra Leone',

      If( WildMatch(Country,'gn*'),'Guinea','Liberia')) as Country

FROM [lib://Downloads/dr-ebolashipments-materiallineitems-07222014to12312014.xlsx]

(ooxml, embedded labels, table is Sheet0);

Did This Work For You??

[dberkesacn]

Delete From ExcelTable;

[joydipp1988]

Hi Debasish,

This can be done by using Mapping Load and ApplyMap functionality. Below are the steps-

1) Prepare one excel data having short names and full names like below-

Country	Country_Full
sl	Sierra Leone
gn	Guinea

2) Go to script and load data from excel like below-

COUNTRY_MAPPING:

Mapping Load

Country,

Country_Full

From <table name>;

Total_Shipments:

Load

Shipment_Qty,

ApplyMap('COUNTRY_MAPPING', Country, 'NA') as Country

From ExcelData;

Hope it will work. Please let us know.

Thanks,

Joy

[Anonymous]

Yes, it worked! Thank you so much, Aar. I can see that all the countries have changed accordingly. Thank you to Daniel as well since I was able to get closer. Removing the line [Country] also helped, Bill.

[Anonymous]

Hello all,

I realize this is unrelated to my previous question and I couldn't thank you all enough. I may have forgotten this, but how can I not display data that is below 1,000 in my visualization. I believe that portion is unnecessary to display. Thanks again!

[Anonymous]

Note: I did uncheck "include null values" so there is data present, although it may not seem so.