topic Consolidation of Chart Values in App Development https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334165#M29189 <HTML><HEAD></HEAD><BODY><P>I have data in a table that I'm trying to count the number of times a word occurs&nbsp; and chart those. The date looks like this</P><P></P><P>Managed Services</P><P>Deployment Services;#Managed Services;#RFP</P><P>Deployment Services</P><P>Fulfillment Services</P><P>Deployment Services;#Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Healthcare;#Professional Services</P><P></P><P>If I chart using</P><P></P><P>if(WildMatch([Group Assignment],'*Fulfillment*'),[Group Assignment])</P><P></P><P>It gives me a column for each unique entry that contains the word Fulfillment, what i'm trying to get to is a single column that shows me a count of every entry that contains the word Fulfillment instead of splitting them out.</P></BODY></HTML> Thu, 27 Apr 2017 16:46:33 GMT 2017-04-27T16:46:33Z Consolidation of Chart Values https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334165#M29189 <HTML><HEAD></HEAD><BODY><P>I have data in a table that I'm trying to count the number of times a word occurs&nbsp; and chart those. The date looks like this</P><P></P><P>Managed Services</P><P>Deployment Services;#Managed Services;#RFP</P><P>Deployment Services</P><P>Fulfillment Services</P><P>Deployment Services;#Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Fulfillment Services</P><P>Healthcare;#Professional Services</P><P></P><P>If I chart using</P><P></P><P>if(WildMatch([Group Assignment],'*Fulfillment*'),[Group Assignment])</P><P></P><P>It gives me a column for each unique entry that contains the word Fulfillment, what i'm trying to get to is a single column that shows me a count of every entry that contains the word Fulfillment instead of splitting them out.</P></BODY></HTML> Thu, 27 Apr 2017 16:46:33 GMT https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334165#M29189 2017-04-27T16:46:33Z Re: Consolidation of Chart Values https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334166#M29190 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>If(WildMatch([Group Assignment],'*Fulfillment*'), '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Fulfillment', </SPAN>[Group Assignment])</STRONG></SPAN></P></BODY></HTML> Thu, 27 Apr 2017 16:51:43 GMT https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334166#M29190 sunny_talwar 2017-04-27T16:51:43Z Re: Consolidation of Chart Values https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334167#M29191 <HTML><HEAD></HEAD><BODY><P>Or just this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(WildMatch([Group Assignment],'*Fulfillment*'), '<SPAN style="font-weight: inherit; font-style: inherit;">Fulfillment'</SPAN>)</STRONG></P></BODY></HTML> Thu, 27 Apr 2017 16:52:12 GMT https://community.qlik.com/t5/App-Development/Consolidation-of-Chart-Values/m-p/1334167#M29191 sunny_talwar 2017-04-27T16:52:12Z