Sort Field values into categories. Some values must be counted in several categories

[adrienL]

Hello,
I recently started Qlik and need some help for this one.

I have a field that contains values like :

Field

A

B

C

A B

A B C

And I want to be able to count how many rows contains 'A','B' and 'C'.

So rows like 'AB' must be counted  once for each A and B

That would give :

Field_type	count
A	3
B	3
C	2

How can i achieve that ?

Any help would be welcomed 🙂

[anat]

create new field using  subfield function at backend t,

then create table to count how many times char is repeating

[anat]

load *,subfield(field,' ') as nf;

load * inline [

field

A

B

C

A B

A B C

];

[adrienL]

ty @anat 
subfield(field,' ') doest just fine !

[anat]

Test:

load *,subfield(field,' ') as nf;

load * inline [

field

A

B

C

A B

A B C

];

noconcatenate

Test1:

load nf,count(nf) resident Test group by nf;

drop table Test;