Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
absekrafi
Creator III
Creator III

Grouping fields of one dimension

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

1 Solution

Accepted Solutions
absekrafi
Creator III
Creator III
Author

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

View solution in original post

4 Replies
MK9885
Master II
Master II

could you please explain more?

absekrafi
Creator III
Creator III
Author

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.

achettipalli
Creator
Creator

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!

absekrafi
Creator III
Creator III
Author

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