I wanted to group values of a variable in a pivot chart to create a group so that i can read the combined results.
For example: I have a pivot chart with sales and states. I want to group certain states in the pivot chart and compare them with the rest (Similar to Group functionality in Excel Pivot).
The example you have shared groups the values using the load statement in the edit script. I was wondering if there is any way in which we can group the values of a variable dynamically (giving the user the flexibility to group based on his requirement) in the qlikview application itself, without having to reload the data using edit script every time.
The only way we have been able to do this is by creating input boxes & assigning them variables for any field that may need dynamic groups created. Another method I can think of would be using bookmarks, but the downside of this is that all other selections are reset when the bookmark is selected.
