topic pivot table total count 0 & expression issue in QlikView

topic pivot table total count 0 & expression issue in QlikView https://community.qlik.com/t5/QlikView/pivot-table-total-count-0-expression-issue/m-p/436942#M1304899 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>Have following issues in my pivot table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000; text-align: right;">125</TD><TD style="border: 1px solid #000000; text-align: right;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000; text-align: right;">100</TD><TD style="border: 1px solid #000000; text-align: right;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000; text-align: right;">50</TD><TD style="border: 1px solid #000000; text-align: right;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">TOTAL</TD><TD style="border: 1px solid #000000; text-align: right;">0</TD><TD style="border: 1px solid #000000; text-align: right;">0</TD><TD style="border: 1px solid #000000; text-align: right;"></TD></TR><TR><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>Total gives my 0 ?? Any clues ?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TOOL</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000;">CRANE1</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">CRANE 2</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>I inserted a new field tool but only want to have the view as below</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TOOL</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000;">CRANE1</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">CRANE2</TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>Thanks for helping me out with these issues</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z pivot table total count 0 & expression issue https://community.qlik.com/t5/QlikView/pivot-table-total-count-0-expression-issue/m-p/436942#M1304899 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>Have following issues in my pivot table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000; text-align: right;">125</TD><TD style="border: 1px solid #000000; text-align: right;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000; text-align: right;">100</TD><TD style="border: 1px solid #000000; text-align: right;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000; text-align: right;">50</TD><TD style="border: 1px solid #000000; text-align: right;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">TOTAL</TD><TD style="border: 1px solid #000000; text-align: right;">0</TD><TD style="border: 1px solid #000000; text-align: right;">0</TD><TD style="border: 1px solid #000000; text-align: right;"></TD></TR><TR><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000; text-align: right;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>Total gives my 0 ?? Any clues ?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TOOL</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000;">CRANE1</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">CRANE 2</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>I inserted a new field tool but only want to have the view as below</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>START SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>END SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE SHIFT</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TOOL</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>WEIGHT HANDLED</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>QTY</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>PARTNO</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">S1</TD><TD style="border: 1px solid #000000;">14:00</TD><TD style="border: 1px solid #000000;">21:45</TD><TD style="border: 1px solid #000000;">14/01/2013</TD><TD style="border: 1px solid #000000;">CRANE1</TD><TD style="border: 1px solid #000000;">125</TD><TD style="border: 1px solid #000000;">15</TD><TD style="border: 1px solid #000000;">CRATE</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">CRANE2</TD><TD style="border: 1px solid #000000;">100</TD><TD style="border: 1px solid #000000;">10</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;">50</TD><TD style="border: 1px solid #000000;">5</TD><TD style="border: 1px solid #000000;">CASES</TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR><TR><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD><TD style="border: 1px solid #000000;"></TD></TR></TBODY></TABLE><P></P><P>Thanks for helping me out with these issues</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/pivot-table-total-count-0-expression-issue/m-p/436942#M1304899 2026-01-26T18:19:17Z Re: pivot table total count 0 & expression issue https://community.qlik.com/t5/QlikView/pivot-table-total-count-0-expression-issue/m-p/436943#M1304900 <HTML><HEAD></HEAD><BODY><P>current expression used :</P><P></P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$<</SPAN><SPAN style="color: #800000; font-size: 8pt;">MCH_CODE</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"SH*"</SPAN><SPAN style="font-size: 8pt;">}>}</SPAN><SPAN style="color: #800000; font-size: 8pt;">WEIGHT_HANDLED</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Sun, 20 Jan 2013 13:24:35 GMT https://community.qlik.com/t5/QlikView/pivot-table-total-count-0-expression-issue/m-p/436943#M1304900 2013-01-20T13:24:35Z