How to evaluate text data from different fields as a whole?

Dik — Sat, 16 Nov 2024 19:54:52 GMT

Hello guys,

I hope someone can understand my "struggle" and has an idea how to deal with it. Since I'm still quite new to to Qlik be patient, thanks! 😊

I got a messy Excel file. One column contains names of persons who are responsible for particular tasks. Sometimes this column contains just one name, sometimes two or more names divided by "," or ";" or "/" or something else... After loading the data, I used the Qlik functionality to split the names. As a result I do now have 4 columns (data fields) in Qlik which contain the names. Sometimes just one name in the 1st column, sometimes two names in both the 1st and 2nd column, etc. Maybe important: the name of a person can appear in every column (but of course not within one data record).

Is there a way to evaluate this data (from these 4 columns) as whole even the names are in different columns? For example if Max Smith appears 8 times in column A and 3 times in column B, how can I show that he is involved in a total of 11 tasks (e.g. in a chart)?

Thank you!

Re: How to evaluate text data from different fields as a whole?

StarinieriG — Fri, 11 Oct 2019 15:38:58 GMT

Hi,

maybe you could try with an expression like this

Count(If(Len(column1)>0,column1)+Count(If(Len(column2)>0,column2)...ect

topic Re: How to evaluate text data from different fields as a whole? in App Development

How to evaluate text data from different fields as a whole?

Re: How to evaluate text data from different fields as a whole?