topic How to know if field dimension is total in App Development https://community.qlik.com/t5/App-Development/How-to-know-if-field-dimension-is-total/m-p/2431706#M96655 <TABLE style="height: 214px; width: 300px;" width="300"> <TBODY> <TR> <TD width="104.229px" height="24px">(Region / Monthly Sales)</TD> <TD width="72.3958px" height="24px">January</TD> <TD width="74.7083px" height="24px">February</TD> </TR> <TR> <TD width="104.229px" height="24px"><EM><STRONG>All Regions</STRONG></EM></TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="46px"><STRONG>All Online Stores</STRONG></TD> <TD width="72.3958px" height="46px">…</TD> <TD width="74.7083px" height="46px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="24px">Philippines</TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="24px">Austria</TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <DIV>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.</DIV> <DIV>The problem is that All Stores will double count Online Stores, once from the Region 'Online Store', and then from each region.</DIV> <DIV>Is there anyway to prevent double count?</DIV> <DIV>&nbsp;</DIV> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 18 Mar 2024 07:36:10 GMT LiquidSword 2024-03-18T07:36:10Z How to know if field dimension is total https://community.qlik.com/t5/App-Development/How-to-know-if-field-dimension-is-total/m-p/2431706#M96655 <TABLE style="height: 214px; width: 300px;" width="300"> <TBODY> <TR> <TD width="104.229px" height="24px">(Region / Monthly Sales)</TD> <TD width="72.3958px" height="24px">January</TD> <TD width="74.7083px" height="24px">February</TD> </TR> <TR> <TD width="104.229px" height="24px"><EM><STRONG>All Regions</STRONG></EM></TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="46px"><STRONG>All Online Stores</STRONG></TD> <TD width="72.3958px" height="46px">…</TD> <TD width="74.7083px" height="46px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="24px">Philippines</TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> <TR> <TD width="104.229px" height="24px">&nbsp;</TD> <TD width="72.3958px" height="24px">&nbsp;</TD> <TD width="74.7083px" height="24px">&nbsp;</TD> </TR> <TR> <TD width="104.229px" height="24px">Austria</TD> <TD width="72.3958px" height="24px">…</TD> <TD width="74.7083px" height="24px">…</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <DIV>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.</DIV> <DIV>The problem is that All Stores will double count Online Stores, once from the Region 'Online Store', and then from each region.</DIV> <DIV>Is there anyway to prevent double count?</DIV> <DIV>&nbsp;</DIV> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 18 Mar 2024 07:36:10 GMT https://community.qlik.com/t5/App-Development/How-to-know-if-field-dimension-is-total/m-p/2431706#M96655 LiquidSword 2024-03-18T07:36:10Z