Bifurcate columns on certain conditions

[arvsuri007]

Hi team,

I am facing problem with bifurcation of a column and the data values remains the same. Just as an example, if I have different country names under one column and with certain sales revenue. How would I show it in qlik sense graphs as single country name with its respective value. Data is somewhat like below:

Country Name	Sales Revenue
Argentina; Australia; Austria; Belgium; Brazil; Canada; Chile	£1,256
Portugal; Romania; Russian Federation; Serbia; Singapore	£246
Ireland; Israel; Italy; Japan; Korea, Republic of; Lithuania; Malaysia; Mexico	£852
Egypt; Estonia; Finland; France; Germany; Greece; Hong Kong; Hungary	£2,669
Switzerland; Taiwan; Thailand; Ukraine; United Kingdom; United States	£822
Netherlands; New Zealand; Norway; Peru; Philippines; Poland	£25
China; Colombia; Croatia; Czechia; Denmark	£6,852

Please suggest.

Regards,

Arvind

[mato32188]

Hi Arvind,
use subfield in your script editor:
Load
subfield([Country Name],';') as [Country Name],
Revenue
FROM your folder;

BR
Martin

[HirisH_V7]

Do use Above with something like this,

Trim(subfield([Country Name],';')) as [Country Name]