topic Re: Sort Field values into categories. Some values must be counted in several categories in QlikView

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

adrienL — Tue, 18 Jan 2022 12:00:24 GMT

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 🙂

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

anat — Tue, 18 Jan 2022 12:28:14 GMT

create new field using subfield function at backend t,

then create table to count how many times char is repeating

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

anat — Tue, 18 Jan 2022 12:33:42 GMT

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

load * inline [

field

A

B

C

A B

A B C

];

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

adrienL — Tue, 18 Jan 2022 14:19:35 GMT

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

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

anat — Wed, 19 Jan 2022 03:07:39 GMT

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;