topic Group values of a variable in pivot chart in QlikView

Group values of a variable in pivot chart

Fri, 05 Aug 2011 20:49:52 GMT

Hi all,

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).

Pls share your ideas on this.

Tkx

Re: Group values of a variable in pivot chart

Mon, 08 Aug 2011 06:30:05 GMT

Hi,

Please find the attaached sample may give you some direction to meet your requirement.

Cheers.

Group values of a variable in pivot chart

Mon, 08 Aug 2011 16:37:56 GMT

Hi BlackRockS,

Thank you for your response.

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.

Tkx.

Group values of a variable in pivot chart

Mon, 08 Aug 2011 17:42:27 GMT

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.