Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arvsuri007
Contributor II
Contributor II

Bifurcate columns on certain conditions

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 NameSales 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

Labels (1)
2 Replies
mato32188
Specialist
Specialist

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

BR
Martin
ECG line chart is the most important visualization in your life.
HirisH_V7
Master
Master

Do use Above with something like this,

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

HirisH
“Aspire to Inspire before we Expire!”