topic Re: Global Grouping Mode in QlikView

Global Grouping Mode

mohammadkhatimi — Tue, 16 Jun 2015 06:27:02 GMT

Can anyone explain me global grouping mode with example.

This mode is in dimension limits tab of chart properties.

Regards,

Mohammad

Re: Global Grouping Mode

mohammadkhatimi — Tue, 16 Jun 2015 09:52:07 GMT

??????????????????

Re: Global Grouping Mode

aveeeeeee7en — Tue, 16 Jun 2015 10:04:10 GMT

Global Grouping Mode: With this option, it is possible to treat the dimension values as either ‘local’ to the current upper dimension level in the chart, or ‘global’ to be evaluated across all instance of the upper level dimensions. This option is only applicable to the second or lower level dimensions on a chart.

For Better Clarity, Read this Post:

QlikView 11 Dimension Limit Functionality

Regards

Av7eN

Re: Global Grouping Mode

mohammadkhatimi — Tue, 16 Jun 2015 10:09:04 GMT

Plzzzzzz Can u explain me by giving live example (Attach qvw)???

I am unable to understand how its work...

Regards,

Mohammad

Re: Global Grouping Mode

aveeeeeee7en — Tue, 16 Jun 2015 10:31:20 GMT

See this:

Regards

Av7eN

Re: Global Grouping Mode

mohammadkhatimi — Tue, 16 Jun 2015 11:27:01 GMT

Still I didnt understood the global grouping mode..

On which basis it showing the largest 4 ????

Re: Global Grouping Mode

diego_a_barboza — Wed, 30 Sep 2015 13:35:11 GMT

Whenever you set dimension limits, they could be set up taking into account the values on the first expression (largest values) or order of the records in the field that is being used as dimension (first values or last records)

Now, in Aveeeeeee7en‌'s sample, you see that you can either:

See which are the Product Families that are top performers in their particular region (Global Grouping Disabled)
Or see which Product Families are your top performers (Global) and check their performance by region (Global Grouping Enabled)

As you can see, in "Global Grouping" the product families are always the same in all the regions (since these are your top performers at global level) but when this option is disabled, you will see that there are some Product Families that are have a better performance in some particular regions.