Splitting fields

[Agnie]

Hi,

My source field is a multi select field. It is applicable to multiple zones and when I use the field in Qlik Sense I get the bar report  like below, Is there a possibility to add a function to get the result as in my expected output? the options are split by a comma in the source field.

Count per zone

EMEA, AP - 40

AP - 20

NA - 65

NA, LA - 20

Expected output

EMEA - 40

AP - 60

NA - 85

LA - 20

[MayilVahanan]

Hi @Agnie 

 the options are split by a comma in the source field

-- For this, try with subfield() function

Load SubField(YourFieldName, ',') as YourFieldName, .. from yoursource;