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?
In the script you can do this:
If(Match(Names, 'Bob', 'Elly'), Names) as NewNames
or You can do that in UI as well with an expression while creating a dimension. Click on "fx" and add below expression.
Thank you. I was looking for a way to do this from UI. I think the nice thing about Qlik Sense is this feature.
Always do this type of logic in Script, it improves the performance. Calculated dimensions is not suggested to use because of performance issues.
Load * Inline
Try like this
If(MixMatch(Names , 'Bob', 'Elly'), Names) AS NewDimensionName
Hope this helps you.
Retrieving data ...