topic Re: Dividing my data in QlikView https://community.qlik.com/t5/QlikView/Dividing-my-data/m-p/1121135#M919537 <HTML><HEAD></HEAD><BODY><P>You can do like this in the script</P><P></P><P><STRONG>LOAD Subfield(Totals, ',', 1) as Number,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Totals, ',', 2) as Text</STRONG></P><P><STRONG>FROM ....</STRONG></P></BODY></HTML> Wed, 11 May 2016 17:53:51 GMT sunny_talwar 2016-05-11T17:53:51Z Dividing my data https://community.qlik.com/t5/QlikView/Dividing-my-data/m-p/1121134#M919536 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a dimension that shows two different values separated by a comma, can I get these two values in to two different columns/dimensions?</P><P></P><P>I would like to have the numbers (ex. 102 or 105) in one column of the table and the letter combinations in one.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/124247_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dividing-my-data/m-p/1121134#M919536 Anonymous 2020-11-25T16:16:04Z Re: Dividing my data https://community.qlik.com/t5/QlikView/Dividing-my-data/m-p/1121135#M919537 <HTML><HEAD></HEAD><BODY><P>You can do like this in the script</P><P></P><P><STRONG>LOAD Subfield(Totals, ',', 1) as Number,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Totals, ',', 2) as Text</STRONG></P><P><STRONG>FROM ....</STRONG></P></BODY></HTML> Wed, 11 May 2016 17:53:51 GMT https://community.qlik.com/t5/QlikView/Dividing-my-data/m-p/1121135#M919537 sunny_talwar 2016-05-11T17:53:51Z