Collating and Returning # of Countries per active order

[ACC]

Hi All,

New to Qlik and a big learning curve!!

We have data  from Sharepoint where the country is in 1 field and separated by a , or #. Within that field the countries listed are varied and differ per order...  For Example

Order 1 has Australia, NZ, Laos, Vietnam.

Order 2 has Vietnam, Laos, China, Nepal

Order 3 has Nepal, Australia

Previously in excel I would just delimit and separate the country field and then created a table with a countif function to get the total number of Active Order per Country... and in turn show as a Bar Graph..

How can I do this in Qlik Sense? Outcome= will be Active Orders per country used.

Example above would be: Australia 2, Vietnam 2,  NZ 1, Laos 2, China 1, Nepal 2

Thank you

[vinieme12]

Use the Subfield() function to split your Country field into rows

example =   Subfield(Country,',') as Country  <<-- this will result in 1 row for each country value

result

Order,Country

Order1,Aus

Order1,NZ

Order1,Laos

Order1,Viet

Order2,Viet

Order2,Laos

..........