Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
create new field using subfield function at backend t,
then create table to count how many times char is repeating
load *,subfield(field,' ') as nf;
load * inline [
field
A
B
C
A B
A B C
];
ty @anat
subfield(field,' ') doest just fine !
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;