Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 -
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?
Go to Solution.
In the script (backend), you can do:
Text(SALE_CD) as SALE_CD
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.
Pretty novice here - convert them to text within Qlik Sense? If so how?