topic Re: Grouping fields of one dimension in QlikView

Grouping fields of one dimension

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

I wasn't able to attach this image to the previous discussion, so I created a new one.

Re: Grouping fields of one dimension

sunny_talwar — Mon, 29 Oct 2018 14:16:36 GMT

What exactly are you trying to group into one dimension? How should the above table look like?

Re: Grouping fields of one dimension

absekrafi — Mon, 29 Oct 2018 14:26:09 GMT

Lest say, I sell my product to Europe, North America and Asia .

In my pivot table I have the total of quantity sold to each continent by selecting the date interval.

Know I want to get the total of all quantity sold in the world, by my company.

For example my company name is COMPANY. I want to see the total of sold quantity in Europe, North america and Asia. When I expand it, I see the quantity sold in each continent.

Re: Grouping fields of one dimension

absekrafi — Mon, 29 Oct 2018 16:08:42 GMT

Hi Sunny,

I found a solution to what I want.

I cheched sub-totals, in pivot table, and I added :

=if(GetSelectedCount(REGION)=0, 'Total GCT', 'Total '&REGION) in the label.

It's working.

Thank you