topic Re: How to count the particular Strings - Qlik Sense in App Development

How to count the particular Strings - Qlik Sense

Subburaj — Tue, 21 Dec 2021 21:56:36 GMT

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, CK5, CLP

AEN, CHD, CLP, XDB

AEN, CLP

AEN, JFF, XDB

AEN, XDB

CBQ

CBS, CLP

CHD

CHD, CK5, CLP

I would like to count each code like below.

What I have to use it in measure & dimension?

Appreciate your help.

GaryGiles — Sat, 24 Apr 2021 17:02:04 GMT

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 — Sat, 24 Apr 2021 17:16:35 GMT

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