Create new dimension with subset of the dimension

[#1]

Hi,

If I have a dimension called Names with values Joe, Bob, James, Elly, how can I create a new dimension with only Bob and Elly?

Thank you.

[sunny_talwar]

In the script you can do this:

LOAD Names,

          If(Match(Names, 'Bob', 'Elly'), Names) as NewNames

          Otherfields

FROM xyz;

[phaneendra_kunc · Accepted solution]

or You can do that in UI as well with an expression while creating a dimension. Click on "fx" and add below expression.

=if(wildmatch(Names,'Bob','Elly'),Names,null())

[handry_orozco]

Load * Inline

[NameId, Name

1,Bob

2,Elly];

[jagan]

Hi,

Try like this

LOAD

*,

If(MixMatch(Names , 'Bob', 'Elly'), Names) AS NewDimensionName

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[#6]

Thank you. I was looking for a way to do this from UI. I think the nice thing about Qlik Sense is this feature.

[jagan]

Hi Allen,

Always do this type of logic in Script, it improves the performance.  Calculated dimensions is not suggested to use because of performance issues.

Regards,

Jagan.