Solved: Multiple Answers in one cell - Qlik Community

Anonymous · ‎2017-09-22

I have multiple answers in a cell all separated by commas and I need to count how many are in the cell how do I count them ? I can't fix this in the excel spread sheet (part of the requirement). I have this problem for many rows.

sunny_talwar · ‎2017-09-22

May be this

SubStringCount(FieldName, ',') + 1

View solution in original post

sunny_talwar · ‎2017-09-22

May be this

SubStringCount(FieldName, ',') + 1

Anonymous · ‎2017-09-22

Thank you that was correct!

Anonymous · ‎2017-09-22

What is the +1 for though?

sunny_talwar · ‎2017-09-22

My guess is that you will have one less separator (comma) than the actual values you are separating... so I am counting the number of commas and then adding 1 to it

Anonymous · ‎2017-09-22

Wonderful I appreciate the help!

Multiple Answers in one cell

function