Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
or You can do that in UI as well with an expression while creating a dimension. Click on "fx" and add below expression.
In the script you can do this:
If(Match(Names, 'Bob', 'Elly'), Names) as NewNames
Load * Inline
Try like this
If(MixMatch(Names , 'Bob', 'Elly'), Names) AS NewDimensionName
Hope this helps you.
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.