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

MK9885 — Mon, 29 Oct 2018 14:56:28 GMT

could you please explain more?

Re: Grouping fields of one dimension

absekrafi — Mon, 29 Oct 2018 15:02:21 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

achettipalli — Mon, 29 Oct 2018 15:22:24 GMT

You have different presentation options:

1.Can add the Company dimension before the Continent field in the pivot table.

2. Add a List box filter of company field.

3. Create set analysis of company field in the expression field like Count({<Company = {'Company'}>}sales)

Good luck!

Re: Grouping fields of one dimension

absekrafi — Mon, 29 Oct 2018 16:06:52 GMT

Hi Avinash,

I found a solution to what I want.

I cheched sub-totals and I added :

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

It's working.

Thank you