If I have a field called “city” in my source data and there are city A, B, C, D, E, F, G under it. I want to group city A and B to “east”, group C and D, E to “middle”, group F and G to “west”. And want “east”, “ middle”, “west” under a new field called “REGION”.
Can this be achieved in Qlik sense? How shall I do? Many thanks!
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: