topic Re: Multiple Answers in one cell in App Development https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400956#M32561 <HTML><HEAD></HEAD><BODY><P>What is the +1 for though?</P></BODY></HTML> Fri, 22 Sep 2017 19:03:42 GMT Anonymous 2017-09-22T19:03:42Z Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400953#M32558 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400953#M32558 Anonymous 2021-12-22T15:42:54Z Re: Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400954#M32559 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>SubStringCount(FieldName, ',') + 1</STRONG></P></BODY></HTML> Fri, 22 Sep 2017 18:55:38 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400954#M32559 sunny_talwar 2017-09-22T18:55:38Z Re: Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400955#M32560 <HTML><HEAD></HEAD><BODY><P>Thank you that was correct!</P></BODY></HTML> Fri, 22 Sep 2017 19:03:13 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400955#M32560 Anonymous 2017-09-22T19:03:13Z Re: Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400956#M32561 <HTML><HEAD></HEAD><BODY><P>What is the +1 for though?</P></BODY></HTML> Fri, 22 Sep 2017 19:03:42 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400956#M32561 Anonymous 2017-09-22T19:03:42Z Re: Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400957#M32562 <HTML><HEAD></HEAD><BODY><P>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 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 22 Sep 2017 19:04:55 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400957#M32562 sunny_talwar 2017-09-22T19:04:55Z Re: Multiple Answers in one cell https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400958#M32563 <HTML><HEAD></HEAD><BODY><P>Wonderful I appreciate the help!</P></BODY></HTML> Fri, 22 Sep 2017 19:08:06 GMT https://community.qlik.com/t5/App-Development/Multiple-Answers-in-one-cell/m-p/1400958#M32563 Anonymous 2017-09-22T19:08:06Z