https://community.qlik.com/t5/QlikView/Chart-count-substring/m-p/1566449#M441783 <P>I have a data set that includes a pay code.&nbsp; Each entry can have more than one pay code.&nbsp; I want to display a count of all pay codes.&nbsp; But I don't want to create a sub string in the load statement because I don't want a new row created for each instance when the data encounters a record with multiple pay codes.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="rowcount.PNG" style="width: 75px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9696i9865E0F32E997627/image-size/large?v=v2&amp;px=999" role="button" title="rowcount.PNG" alt="rowcount.PNG" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="countchart.PNG" style="width: 538px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9697i70170790D8F0DF86/image-size/large?v=v2&amp;px=999" role="button" title="countchart.PNG" alt="countchart.PNG" /></span></P><P>I tried creating a calculated dimension where&nbsp;=SubField(TCF_LINE_PAY_WEB_CODE, ', ') and then doing an expression&nbsp;Count({&lt;METRIC_VALUE={'TCF'}&gt;}Distinct INTEGRATION_ID). But when I select certain pay codes they don't align. For example, If I click pay code 4 in the chart, pay code 12 is displayed on the pie chart.</P><P>&nbsp;</P> Mon, 08 Apr 2019 13:50:44 GMT justcotto 2019-04-08T13:50:44Z https://community.qlik.com/t5/QlikView/Chart-count-substring/m-p/1566449#M441783 <P>I have a data set that includes a pay code.&nbsp; Each entry can have more than one pay code.&nbsp; I want to display a count of all pay codes.&nbsp; But I don't want to create a sub string in the load statement because I don't want a new row created for each instance when the data encounters a record with multiple pay codes.<span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="rowcount.PNG" style="width: 75px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9696i9865E0F32E997627/image-size/large?v=v2&amp;px=999" role="button" title="rowcount.PNG" alt="rowcount.PNG" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="countchart.PNG" style="width: 538px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9697i70170790D8F0DF86/image-size/large?v=v2&amp;px=999" role="button" title="countchart.PNG" alt="countchart.PNG" /></span></P><P>I tried creating a calculated dimension where&nbsp;=SubField(TCF_LINE_PAY_WEB_CODE, ', ') and then doing an expression&nbsp;Count({&lt;METRIC_VALUE={'TCF'}&gt;}Distinct INTEGRATION_ID). But when I select certain pay codes they don't align. For example, If I click pay code 4 in the chart, pay code 12 is displayed on the pie chart.</P><P>&nbsp;</P> Mon, 08 Apr 2019 13:50:44 GMT https://community.qlik.com/t5/QlikView/Chart-count-substring/m-p/1566449#M441783 justcotto 2019-04-08T13:50:44Z https://community.qlik.com/t5/QlikView/Chart-count-substring/m-p/1566462#M441784 Why not move the TCF_LINE_PAY_WEB_CODE as a separate table and do the subfield in script?<BR />so no duplicate rows of the main table occur Mon, 08 Apr 2019 14:16:57 GMT https://community.qlik.com/t5/QlikView/Chart-count-substring/m-p/1566462#M441784 dplr-rn 2019-04-08T14:16:57Z