topic Re: How to show missing values as zero in straight table. in QlikView https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446809#M433488 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Maybe this?</P><P><IMG __jive_id="187967" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187967_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 22 Dec 2017 10:00:01 GMT antonaks 2017-12-22T10:00:01Z How to show missing values as zero in straight table. https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446807#M433486 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>How to show missing values as zero in straight table.</P><P>Dim: Month</P><P>Measure: Sum(Revenue)</P><P>Raw data:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Month</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Revenue</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">100</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">200</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">300</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"></P></TD></TR></TBODY></TABLE><P></P><P>Required output:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 0px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Month</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Revenue</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">100</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">200</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">300</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">11</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">12</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Total</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="66"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">600</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Krishna</P></BODY></HTML> Fri, 22 Dec 2017 09:55:32 GMT https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446807#M433486 Anonymous 2017-12-22T09:55:32Z Re: How to show missing values as zero in straight table. https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446808#M433487 <HTML><HEAD></HEAD><BODY><P>Maybe with: alt(Sum(Revenue), 0)</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Dec 2017 09:59:00 GMT https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446808#M433487 marcus_sommer 2017-12-22T09:59:00Z Re: How to show missing values as zero in straight table. https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446809#M433488 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Maybe this?</P><P><IMG __jive_id="187967" alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187967_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 22 Dec 2017 10:00:01 GMT https://community.qlik.com/t5/QlikView/How-to-show-missing-values-as-zero-in-straight-table/m-p/1446809#M433488 antonaks 2017-12-22T10:00:01Z