Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sdealtrey
New Contributor

Match Function Issue with Filtering

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

1 Solution

Accepted Solutions
CarlosAMonroy
Contributor III

Re: Match Function Issue with Filtering

In the script (backend), you can do:

Load

...

Text(SALE_CD) as SALE_CD

...

From Table

Regards,

Carlos

3 Replies
CarlosAMonroy
Contributor III

Re: Match Function Issue with Filtering

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

sdealtrey
New Contributor

Re: Match Function Issue with Filtering

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

Thanks

CarlosAMonroy
Contributor III

Re: Match Function Issue with Filtering

In the script (backend), you can do:

Load

...

Text(SALE_CD) as SALE_CD

...

From Table

Regards,

Carlos