Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the script (backend), you can do:
Load
...
Text(SALE_CD) as SALE_CD
...
From Table
Regards,
Carlos
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
Pretty novice here - convert them to text within Qlik Sense? If so how?
Thanks
In the script (backend), you can do:
Load
...
Text(SALE_CD) as SALE_CD
...
From Table
Regards,
Carlos