Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

aashish591
New Contributor II

How to calculate the occurrence of names in rows and string inside rows

Hi Experts,

I am come across a situation where i need to calculate the no of occurrence of individual names presents in rows of field and string inside a field.

string inside rows are saparated by ";" (semicolon).

Please help me out to resolve this issue.

Is there any way to get all the semicolon separated values in new row??

Thanks in advance. Please find the attached data file and sample qvw.

Regards,

aashish.

1 Solution

Accepted Solutions

Re: How to calculate the occurrence of names in rows and string inside rows

See attached example.


talk is cheap, supply exceeds demand
2 Replies

Re: How to calculate the occurrence of names in rows and string inside rows

See attached example.


talk is cheap, supply exceeds demand
aashish591
New Contributor II

Re: How to calculate the occurrence of names in rows and string inside rows

Thanks Gysbert!!

Community Browser