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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LiquidSword
Partner - Contributor III
Partner - Contributor III

How to know if field dimension is total

(Region / Monthly Sales) January February
All Regions
     
All Online Stores
     
Philippines
     
Austria

 

In my dataset, Online Store are a type of store every country has. In the Region dimension. Online Store has dimension#=1 and Countries has dimension#=2. Pick() is used to show both Online Stores and Countries.
The problem is that All Stores will double count Online Stores, once from the Region 'Online Store', and then from each region.
Is there anyway to prevent double count?
 

 

 

Labels (2)
0 Replies