Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kellymcgrady
Contributor

Multiple Answers in one cell

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Multiple Answers in one cell

May be this

SubStringCount(FieldName, ',') + 1

5 Replies

Re: Multiple Answers in one cell

May be this

SubStringCount(FieldName, ',') + 1

kellymcgrady
Contributor

Re: Multiple Answers in one cell

Thank you that was correct!

kellymcgrady
Contributor

Re: Multiple Answers in one cell

What is the +1 for though?

Re: Multiple Answers in one cell

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

kellymcgrady
Contributor

Re: Multiple Answers in one cell

Wonderful I appreciate the help!

Community Browser