topic Pivot table Totals Not Showing....? in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630105#M231266 <HTML><HEAD></HEAD><BODY><P>Can anyone guide me why my pivot table is not showing Total values?</P><P>Segment is a synthetic dimention .</P><TABLE border="0" cellpadding="0" cellspacing="0" height="424" style="width: 682px; height: 371px;"><TBODY><TR><TD class="xl63" height="17" width="69">WeekInMonth</TD><TD class="xl63" style="border-left: none;" width="40">Day</TD><TD class="xl64" width="58">Segment</TD><TD class="xl73" style="border-left: none;" width="94">a</TD><TD class="xl73" style="border-left: none;" width="94">b</TD><TD class="xl73" style="border-left: none;" width="94">c</TD><TD class="xl73" style="border-left: none;" width="94">d</TD><TD class="xl73" style="border-left: none;" width="94">e</TD><TD class="xl73" style="border-left: none;" width="94">f</TD><TD class="xl73" style="border-left: none;" width="94">g</TD><TD class="xl73" style="border-left: none;" width="94">h</TD><TD class="xl73" style="border-left: none;" width="94">i</TD><TD class="xl74" style="border-left: none;" width="94">Total</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Sun</TD><TD class="xl67"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Sat</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Fri</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">24</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3,144</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">766</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(862)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Thu</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">36</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(144)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(143)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">24</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">3,180</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">622</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(1,004)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Mon</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(144)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4,392</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11,777</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,018</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">84</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(42)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Sun</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Sat</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Fri</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">467</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,565</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">14,611</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">455</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Thu</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,198</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(1,885)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9,077</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">382</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2,154</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Wed</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2,153</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(862)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(30)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Tue</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11,056</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,771</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(0)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,520</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">4,072</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">48,675</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,123</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(30)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,855</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">2,567</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week3</TD><TD class="xl66" style="border-top: none; border-left: none;">Mon</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(599)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">820</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4,225</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">14,638</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,460</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,018</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,124</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week3</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(599)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">820</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">4,225</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">14,638</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,460</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,018</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,124</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl72" height="17" style="border-top: none;"><SPAN style="color: #00ff00;">Total</SPAN></TD><TD class="xl70" style="border-top: none;"></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">(599)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,364</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">8,297</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">66,492</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">3,205</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">(30)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,873</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,687</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">-</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 12 May 2014 18:06:54 GMT 2014-05-12T18:06:54Z Pivot table Totals Not Showing....? https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630105#M231266 <HTML><HEAD></HEAD><BODY><P>Can anyone guide me why my pivot table is not showing Total values?</P><P>Segment is a synthetic dimention .</P><TABLE border="0" cellpadding="0" cellspacing="0" height="424" style="width: 682px; height: 371px;"><TBODY><TR><TD class="xl63" height="17" width="69">WeekInMonth</TD><TD class="xl63" style="border-left: none;" width="40">Day</TD><TD class="xl64" width="58">Segment</TD><TD class="xl73" style="border-left: none;" width="94">a</TD><TD class="xl73" style="border-left: none;" width="94">b</TD><TD class="xl73" style="border-left: none;" width="94">c</TD><TD class="xl73" style="border-left: none;" width="94">d</TD><TD class="xl73" style="border-left: none;" width="94">e</TD><TD class="xl73" style="border-left: none;" width="94">f</TD><TD class="xl73" style="border-left: none;" width="94">g</TD><TD class="xl73" style="border-left: none;" width="94">h</TD><TD class="xl73" style="border-left: none;" width="94">i</TD><TD class="xl74" style="border-left: none;" width="94">Total</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Sun</TD><TD class="xl67"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Sat</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Fri</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">24</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">3,144</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">766</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(862)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl66" style="border-top: none; border-left: none;">Thu</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">36</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(144)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(143)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week1</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">24</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">3,180</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">622</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(1,004)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Mon</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(144)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4,392</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11,777</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,018</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">84</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(42)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Sun</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Sat</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Fri</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">467</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,565</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">14,611</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">455</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Thu</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,198</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(1,885)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">9,077</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">382</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2,154</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Wed</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">2,153</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(862)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(30)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl66" style="border-top: none; border-left: none;">Tue</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">11,056</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,771</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(0)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week2</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,520</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">4,072</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">48,675</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,123</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(30)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,855</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">2,567</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week3</TD><TD class="xl66" style="border-top: none; border-left: none;">Mon</TD><TD class="xl67" style="border-top: none;"></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">(599)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">820</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4,225</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">14,638</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,460</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,018</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1,124</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl75" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl65" height="17" style="border-top: none;">Week3</TD><TD class="xl70" style="border-top: none;"><SPAN style="color: #ff0000;">Total</SPAN></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">(599)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">820</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">4,225</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">14,638</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,460</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,018</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">1,124</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #ff0000;">-</SPAN></TD></TR><TR><TD class="xl72" height="17" style="border-top: none;"><SPAN style="color: #00ff00;">Total</SPAN></TD><TD class="xl70" style="border-top: none;"></TD><TD class="xl71" style="border-top: none;"></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">(599)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,364</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">8,297</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">66,492</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">3,205</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">(30)</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,873</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">2,687</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">0</SPAN></TD><TD class="xl75" style="border-top: none; border-left: none;"><SPAN style="color: #00ff00;">-</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 12 May 2014 18:06:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630105#M231266 2014-05-12T18:06:54Z Re: Pivot table Totals Not Showing....? https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630106#M231267 <HTML><HEAD></HEAD><BODY><P>use aggr</P><P></P><P>sum(aggr(<SPAN style="font-size: 10pt; line-height: 1.5em;">&lt;presentExpression&gt;,dimension1,dimension2,dimension3))</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P></BODY></HTML> Mon, 12 May 2014 18:18:43 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630106#M231267 preminqlik 2014-05-12T18:18:43Z Re: Pivot table Totals Not Showing....? https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630107#M231268 <HTML><HEAD></HEAD><BODY><P>Prem,</P><P>Thanks for the replay.</P><P>But what if I am using 'value list' for SynDim within in the chart?</P><P>I can create the Dim from the script side to with "aggr" but is there any way I can solve this within the expression?<SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Mon, 12 May 2014 18:45:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Totals-Not-Showing/m-p/630107#M231268 2014-05-12T18:45:07Z