topic Group field values in Qlik Sense? in App Development https://community.qlik.com/t5/App-Development/Group-field-values-in-Qlik-Sense/m-p/914465#M12632 <HTML><HEAD></HEAD><BODY><P>I'm trying to analyze some dirty data and I'd like to create a custom group where I can select the various spellings of one vendor's name into a single value.&nbsp; What's the easiest way to do this in Qlik Sense?</P><P></P><P>Thanks,</P></BODY></HTML> Thu, 06 Aug 2015 20:23:33 GMT 2015-08-06T20:23:33Z Group field values in Qlik Sense? https://community.qlik.com/t5/App-Development/Group-field-values-in-Qlik-Sense/m-p/914465#M12632 <HTML><HEAD></HEAD><BODY><P>I'm trying to analyze some dirty data and I'd like to create a custom group where I can select the various spellings of one vendor's name into a single value.&nbsp; What's the easiest way to do this in Qlik Sense?</P><P></P><P>Thanks,</P></BODY></HTML> Thu, 06 Aug 2015 20:23:33 GMT https://community.qlik.com/t5/App-Development/Group-field-values-in-Qlik-Sense/m-p/914465#M12632 2015-08-06T20:23:33Z Re: Group field values in Qlik Sense? https://community.qlik.com/t5/App-Development/Group-field-values-in-Qlik-Sense/m-p/914466#M12633 <HTML><HEAD></HEAD><BODY><P>Hi Kathy,</P><P></P><P>One way to accomplish that is by using an INLINE table in the Script Editor so you can group many values into your grouping values.</P><P></P><P>Like this:</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>// previous LOAD sentences...</P> <P></P> <P>MyGroups:</P> <P>LOAD * INLINE [</P> <P>Group, DirtyName</P> <P>Group A, foo1</P> <P>Group A, foo2</P> <P>Group B, foo9</P> <P>];</P> <P></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Then you can use the field "Group" in a sheet to filter your data and also as a Dimension in a chart.</P></BODY></HTML> Fri, 07 Aug 2015 19:32:07 GMT https://community.qlik.com/t5/App-Development/Group-field-values-in-Qlik-Sense/m-p/914466#M12633 2015-08-07T19:32:07Z