topic Re: Error in Pivot Table totals - only &quot;-&quot; show in App Development https://community.qlik.com/t5/App-Development/Error-in-Pivot-Table-totals-only-quot-quot-show/m-p/1107673#M18853 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using? Can you try this:</P><P></P><P><STRONG>Sum(Aggr(<SPAN style="color: #ff0000;">ExpressionPlaceHolder</SPAN>, DIM1, DIM2, DIM3))</STRONG></P><P></P><P>Replace your original Expression with the <STRONG style="color: #ff0000;">ExpressionPlaceHolder</STRONG> above</P></BODY></HTML> Fri, 24 Jun 2016 12:03:21 GMT sunny_talwar 2016-06-24T12:03:21Z Error in Pivot Table totals - only "-" show https://community.qlik.com/t5/App-Development/Error-in-Pivot-Table-totals-only-quot-quot-show/m-p/1107672#M18852 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>I meet a strange error with Qlik Sense Pivot table: it's unable to calculate the total values by dimension:</P><P><IMG alt="ex_.jpg" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/129062_ex_.jpg" style="height: 286px; width: 620px;" /></P><P>(I edited out some details due to confidential problem)</P><P></P><P>I don't use any custom calculation or Aggregation for the measures.</P><P></P><P>I also tried to use formula to set the measures values = 0 if null / blank, but then the total also = 0.</P><P></P><P>Data structure:</P><P><IMG __jive_id="129043" alt="ex2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/129043_ex2.PNG" style="height: auto;" /></P><P>The 3 dimensions DIM1 DIM2 DIM3 has a hierarchy relationship as shown in the first pic.</P><P></P><P>Could someone please help me fixing this?</P><P></P><P>Thanks a lot in advance!</P></BODY></HTML> Fri, 24 Jun 2016 07:39:30 GMT https://community.qlik.com/t5/App-Development/Error-in-Pivot-Table-totals-only-quot-quot-show/m-p/1107672#M18852 2016-06-24T07:39:30Z Re: Error in Pivot Table totals - only "-" show https://community.qlik.com/t5/App-Development/Error-in-Pivot-Table-totals-only-quot-quot-show/m-p/1107673#M18853 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using? Can you try this:</P><P></P><P><STRONG>Sum(Aggr(<SPAN style="color: #ff0000;">ExpressionPlaceHolder</SPAN>, DIM1, DIM2, DIM3))</STRONG></P><P></P><P>Replace your original Expression with the <STRONG style="color: #ff0000;">ExpressionPlaceHolder</STRONG> above</P></BODY></HTML> Fri, 24 Jun 2016 12:03:21 GMT https://community.qlik.com/t5/App-Development/Error-in-Pivot-Table-totals-only-quot-quot-show/m-p/1107673#M18853 sunny_talwar 2016-06-24T12:03:21Z