topic how to split excelsheet cell values in qlikview in QlikView https://community.qlik.com/t5/QlikView/how-to-split-excelsheet-cell-values-in-qlikview/m-p/51599#M767829 <HTML><HEAD></HEAD><BODY><P>Hai experts.</P><P>how to split excel sheet cell values in qlikview. For example my data is below model, i will get data as output &amp; count the values in excel sheet.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sap</TD><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; output</TD><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count</TD></TR><TR><TD style="padding: 2px;">1,2,3</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">6,7</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z how to split excelsheet cell values in qlikview https://community.qlik.com/t5/QlikView/how-to-split-excelsheet-cell-values-in-qlikview/m-p/51599#M767829 <HTML><HEAD></HEAD><BODY><P>Hai experts.</P><P>how to split excel sheet cell values in qlikview. For example my data is below model, i will get data as output &amp; count the values in excel sheet.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sap</TD><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; output</TD><TD style="padding: 2px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count</TD></TR><TR><TD style="padding: 2px;">1,2,3</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">6,7</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-split-excelsheet-cell-values-in-qlikview/m-p/51599#M767829 Anonymous 2020-11-25T16:16:04Z Re: how to split excelsheet cell values in qlikview https://community.qlik.com/t5/QlikView/how-to-split-excelsheet-cell-values-in-qlikview/m-p/51600#M767830 <HTML><HEAD></HEAD><BODY><P>You could use something like this:</P><P></P><P>load sap, subfield(sap, ',') as output, rangesum(substringcount(sap, ','), 1) as count</P><P>from excel;</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 21 Jun 2018 08:52:48 GMT https://community.qlik.com/t5/QlikView/how-to-split-excelsheet-cell-values-in-qlikview/m-p/51600#M767830 marcus_sommer 2018-06-21T08:52:48Z