1 Reply Latest reply: Aug 7, 2015 3:32 PM by Borja Rodriguez RSS

    Group field values in Qlik Sense?

      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.  What's the easiest way to do this in Qlik Sense?

       

      Thanks,

        • Re: Group field values in Qlik Sense?
          Borja Rodriguez

          Hi Kathy,

           

          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.

           

          Like this:

           

          // previous LOAD sentences...

           

          MyGroups:

          LOAD * INLINE [

          Group, DirtyName

          Group A, foo1

          Group A, foo2

          Group B, foo9

          ];

           

           

          Then you can use the field "Group" in a sheet to filter your data and also as a Dimension in a chart.