Questien: how to count a string value

[Anonymous]

Hi,

i am starting to work with qlikview a few weeks ago.

I am able to count all string values in a column but a Special value.

For exampel the column is named Members an in a row the values are:

Klaus

Klaus, Bernd, Olaf

Olaf

Bernd, Manfred

i want to count the Name Klaus.

How do i have to create the code in qlik view?

thank you for your help

Jay

[Anonymous · Accepted solution]

Dear Community, thanks to all of you.

I got a solution with this:

LOAD Subfield(Name,',') as Name

FROM ...;

Then i changed the Settings in the listbox and it counts.

This solution is okay for the first step.

Thanks a lot.

Best regards

jay