topic Looking for Inventory with JUST zero values in QlikView

topic Looking for Inventory with JUST zero values in QlikView https://community.qlik.com/t5/QlikView/Looking-for-Inventory-with-JUST-zero-values/m-p/932718#M978665 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Here is another one.</P><P></P><P>I have an inventory table that looks like this.</P><P>You can see that the column called "vCo$t" has some records where the value is missing (zero or null)</P><P></P><P>          </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 511px;"><TBODY><TR><TD class="xl63" height="17" width="171">ProductID</TD><TD class="xl63" style="border-left: none;" width="36">Others</TD><TD class="xl63" style="border-left: none;" width="38">OH</TD><TD class="xl63" style="border-left: none;" width="44">vCo$t</TD><TD class="xl63" style="border-left: none;" width="53">sCo$t</TD><TD class="xl63" style="border-left: none;" width="36">Load</TD><TD class="xl63" style="border-left: none;" width="44">iCo$t</TD><TD class="xl63" style="border-left: none;" width="36">Delta</TD><TD class="xl63" style="border-left: none;" width="53">O$MI</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">3/8-CHANNEL-GY</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.17</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.32</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.13</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">19%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">4UGR</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$41.58</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$46.74</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$41.58</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$20.79</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">5/8X17/32-EXT</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17,500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.07</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.08</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.07</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">10-39-259</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$19.28</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$28.90</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">10-65-343</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$9.63</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$9.53</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">70-1639</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">55</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$15.05</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$16.92</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$15.05</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($0.00)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">170-9098</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">265</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.26</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.03</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">654%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$2.28</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">170-9121</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.28</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.03</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">717%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">445-144</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">25</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.96</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">445-327</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">19</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$2.46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">447-26</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">18</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$6.40</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($0.00)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11386</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$402.48</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$610.78</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$401.01</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$601.52</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11387</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$582.16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$883.45</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$618.53</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">43%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$618.53</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11406</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$53.00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$80.43</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$52.22</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">54%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$26.11</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11411</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$53.00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$80.43</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$56.72</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">40%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$26.11</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11413</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$98.43</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$149.37</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$97.57</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">53%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">1040-026</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.48</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.66</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.48</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR></TBODY></TABLE><P></P><P style="font-size: 13.3333330154419px;">I want to create a simple table that displays ONLY inventory where the vCo$t is zero or null.</P><P style="font-size: 13.3333330154419px;">I tried to use {<[vCo$t]={0}>} in the expression field for vCo$t but all it does is show all records and gives them all a null vCo$t</P><P>       </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 423px;"><TBODY><TR><TD class="xl65" height="17" width="97">ProductID</TD><TD class="xl65" style="border-left: none;" width="41">OH</TD><TD class="xl65" style="border-left: none;" width="58">vCo$t</TD><TD class="xl65" style="border-left: none;" width="58">sCo$t</TD><TD class="xl65" style="border-left: none;" width="45">Load</TD><TD class="xl65" style="border-left: none;" width="65">iCo$t</TD><TD class="xl65" style="border-left: none;" width="59">Delta</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">10-39-259</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$0.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$28.90</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-100%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIL-2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">24</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$7.42</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$7.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">URE-6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$24.36</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$22.09</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-1800</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">7</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$39.75</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$37.48</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-012-35050X37038</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$111.70</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$105.32</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANG-PRIMER-QT</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$23.46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$22.12</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIG-533-006-60X60</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$500.04</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$471.47</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">VITON-4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$78.35</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$73.08</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">7%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANGLAG60-5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">308</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$14.32</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$19.65</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-27%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANG-CEMENT-QT</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$21.97</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$20.71</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIL-4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$13.62</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$13.85</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-2%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-0200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">55</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$3.40</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$2.99</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$33.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$29.70</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-300-1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$35.01</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$24.13</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">45%</TD></TR></TBODY></TABLE><P></P><P>HELP!</P><P></P><P>Also, how do I use {[Field]={exp}>} if i don't have a formula like "Sum" or "Avg"?</P><P></P><P>Thanks</P></BODY></HTML> Sat, 29 Aug 2015 01:45:36 GMT 2015-08-29T01:45:36Z Looking for Inventory with JUST zero values https://community.qlik.com/t5/QlikView/Looking-for-Inventory-with-JUST-zero-values/m-p/932718#M978665 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Here is another one.</P><P></P><P>I have an inventory table that looks like this.</P><P>You can see that the column called "vCo$t" has some records where the value is missing (zero or null)</P><P></P><P>          </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 511px;"><TBODY><TR><TD class="xl63" height="17" width="171">ProductID</TD><TD class="xl63" style="border-left: none;" width="36">Others</TD><TD class="xl63" style="border-left: none;" width="38">OH</TD><TD class="xl63" style="border-left: none;" width="44">vCo$t</TD><TD class="xl63" style="border-left: none;" width="53">sCo$t</TD><TD class="xl63" style="border-left: none;" width="36">Load</TD><TD class="xl63" style="border-left: none;" width="44">iCo$t</TD><TD class="xl63" style="border-left: none;" width="36">Delta</TD><TD class="xl63" style="border-left: none;" width="53">O$MI</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">3/8-CHANNEL-GY</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.17</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.32</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.13</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">19%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">4UGR</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$41.58</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$46.74</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$41.58</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$20.79</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">5/8X17/32-EXT</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">17,500</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.07</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.08</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.07</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">10-39-259</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">13</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$19.28</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$28.90</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">10-65-343</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$9.63</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$9.53</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">70-1639</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">55</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$15.05</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$16.92</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$15.05</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($0.00)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">170-9098</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">265</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.23</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.26</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.03</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">654%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$2.28</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">170-9121</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.28</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.03</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">717%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">445-144</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">25</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.96</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">445-327</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">19</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$2.46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">447-26</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">18</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$6.40</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($0.00)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11386</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$402.48</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$610.78</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$401.01</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$601.52</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11387</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$582.16</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$883.45</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$618.53</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">43%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$618.53</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11406</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$53.00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$80.43</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$52.22</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">54%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$26.11</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11411</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$53.00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$80.43</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$56.72</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">40%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$26.11</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">600-11413</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$98.43</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$149.37</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">52%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$97.57</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">53%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">1040-026</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.48</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.66</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1.48</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">12%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$0.00</TD></TR></TBODY></TABLE><P></P><P style="font-size: 13.3333330154419px;">I want to create a simple table that displays ONLY inventory where the vCo$t is zero or null.</P><P style="font-size: 13.3333330154419px;">I tried to use {<[vCo$t]={0}>} in the expression field for vCo$t but all it does is show all records and gives them all a null vCo$t</P><P>       </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 423px;"><TBODY><TR><TD class="xl65" height="17" width="97">ProductID</TD><TD class="xl65" style="border-left: none;" width="41">OH</TD><TD class="xl65" style="border-left: none;" width="58">vCo$t</TD><TD class="xl65" style="border-left: none;" width="58">sCo$t</TD><TD class="xl65" style="border-left: none;" width="45">Load</TD><TD class="xl65" style="border-left: none;" width="65">iCo$t</TD><TD class="xl65" style="border-left: none;" width="59">Delta</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">10-39-259</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">13</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$0.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">-100%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$28.90</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-100%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIL-2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">24</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$7.42</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$7.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">URE-6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$24.36</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$22.09</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-1800</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">7</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$39.75</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$37.48</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-012-35050X37038</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$111.70</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$105.32</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANG-PRIMER-QT</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">1</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$23.46</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$22.12</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIG-533-006-60X60</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$500.04</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$471.47</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">VITON-4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">11</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$78.35</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$73.08</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">7%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANGLAG60-5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">308</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$14.32</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$19.65</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-27%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">PANG-CEMENT-QT</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$21.97</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$20.71</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">SIL-4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$13.62</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">6%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$13.85</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">-2%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-0200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">55</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$3.40</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$2.99</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">14%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-150-1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">10</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$33.00</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$29.70</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">RG-SIG-533-006-300-1200</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2</TD><TD class="xl68" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$35.01</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11%</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">$24.13</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">45%</TD></TR></TBODY></TABLE><P></P><P>HELP!</P><P></P><P>Also, how do I use {[Field]={exp}>} if i don't have a formula like "Sum" or "Avg"?</P><P></P><P>Thanks</P></BODY></HTML> Sat, 29 Aug 2015 01:45:36 GMT https://community.qlik.com/t5/QlikView/Looking-for-Inventory-with-JUST-zero-values/m-p/932718#M978665 2015-08-29T01:45:36Z