See attached .qvf file - copy to C:\Users\<your user>\Documents\Qlik\Sense\Apps and restart Sense Desktop.
(NOTE: The LOAD Script contains sample script that is used ONLY to generate sample data for your example.
You can do this in any app by pressing the key combination CTRL + 0 + 0 while in the Data Load Editor)
Open Buckets App.
Better defined as a Dimension in the app, you can used this syntax:
Here is a simple one:
Here is a nested one:
(you could also use this in the load script if you wanted to like this:
if(match(Alpha,'A','B','C','D'),'East',if(match(Alpha,'E','F','G','H'),'West','South')) as Region Bucket
Buckets.qvf 208.0 K
Hi Mike and Josh, you are really nice. thank you a lot for your help.
I have tried Mike's approach. it solved the problem. I had achieved what I wanted to achieve. However, I do miss tableau while I was dealing with this kind of grouping. I urge qlik to make it easier.
I am not keen in scripting so I am sorry that I was not able to understand applymap. Sorry Josh but still appreciate your help.