Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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,

1 Reply
Not applicable

Re: Group field values in Qlik Sense?

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.

Community Browser