How to count the particular Strings - Qlik Sense

[Subburaj]

Hello All,

I have Codes like below in one column. 

Codes

ACY, AEN, CK5, CLN, CS7

ACY, CK5, CLN, CS7

AEN

AEN, CHD

AEN, CHD

AEN, CHD, CK5, CLP

AEN, CHD, CLP, XDB

AEN, CLP

AEN, JFF, XDB

AEN, XDB

CBQ

CBS, CLP

CHD

CHD, CK5, CLP

CHD, CK5, CLP

I would like to count each code like below.

Code	Count
ACY
AEN
CBQ
CBS
CHD
CK5
CLP
JFF
XDB
CS7
CLN

What I have to use it in measure & dimension?

Appreciate your help.

[GaryGiles · Accepted solution]

After the Codes table is loaded in your load script, add the following:

SingleCodes:
Load SubField(Codes,',') as SingleCode,
Codes
Resident Codes;

Then you can use SingleCode as your dimension in your table and Count(Codes) as your measure.

[Subburaj]

Thanks a lot Gary. I got an output as required.🙏