topic Re: Match Function Issue with Filtering in App Development

Match Function Issue with Filtering

Anonymous — Wed, 04 Apr 2018 19:39:22 GMT

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

Re: Match Function Issue with Filtering

CarlosAMonroy — Wed, 04 Apr 2018 19:44:08 GMT

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

Re: Match Function Issue with Filtering

Anonymous — Wed, 04 Apr 2018 19:45:19 GMT

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

Thanks

Re: Match Function Issue with Filtering

CarlosAMonroy — Wed, 04 Apr 2018 19:48:51 GMT

In the script (backend), you can do:

Load

...

Text(SALE_CD) as SALE_CD

...

From Table

Regards,

Carlos