Match Function Issue with Filtering

[Anonymous]

Hello,

I am grouping my sales codes (being used as dimensions) into certain categories. I am using this all in a drill down master dimension.

The issue I am running into is that our company has a sales code "051" and "51". When I am using the following function -

if(MATCH(SALE_CD,'051'),'RETREADS',

Both the "051" and "51" codes are being included. Unfortunately "51" is a in a different category than "051".

Is there a different function other than match that I could use to group these dimension?

Thanks

[CarlosAMonroy]

Hi Scott,

You can use the same function but instead of using the plain field, try to convert the sales code to text, that way you will have two values '051' & 51.

Hope that helps.

Carlos M

[Anonymous]

Pretty novice here - convert them to text within Qlik Sense? If so how?

Thanks

[CarlosAMonroy · Accepted solution]

In the script (backend), you can do:

Load

...

Text(SALE_CD) as SALE_CD

...

From Table

Regards,

Carlos