topic Re: Show only missing and 0 values in QlikView https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035833#M933464 <HTML><HEAD></HEAD><BODY><P>Try this expression</P><P><STRONG>=If(NullCount(Forecast) &gt; 0 or Forecast = 0, 'Show')</STRONG></P><P></P><P>with ItemNr and ItemName as dimensions</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116085_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 26 Feb 2016 07:55:10 GMT sunny_talwar 2016-02-26T07:55:10Z Show only missing and 0 values https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035832#M933463 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I've got three tables, Item, Sales and Forecast:</P><P></P><P><IMG alt="ScreenHunter_01 Feb. 26 08.47.gif" class="jive-image image-1" src="/legacyfs/online/116087_ScreenHunter_01 Feb. 26 08.47.gif" style="height: auto;" /></P><P></P><P>In an object, I want to show only the Items (ItemNr and ItemName) where Forecast is set to 0 or missing at all.</P><P></P><P></P><P>In this case, the result should be:</P><P></P><P><IMG alt="ScreenHunter_03 Feb. 26 08.48.gif" class="jive-image image-2" src="/legacyfs/online/116089_ScreenHunter_03 Feb. 26 08.48.gif" style="height: auto;" /></P></BODY></HTML> Fri, 26 Feb 2016 07:51:17 GMT https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035832#M933463 2016-02-26T07:51:17Z Re: Show only missing and 0 values https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035833#M933464 <HTML><HEAD></HEAD><BODY><P>Try this expression</P><P><STRONG>=If(NullCount(Forecast) &gt; 0 or Forecast = 0, 'Show')</STRONG></P><P></P><P>with ItemNr and ItemName as dimensions</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116085_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 26 Feb 2016 07:55:10 GMT https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035833#M933464 sunny_talwar 2016-02-26T07:55:10Z Re: Show only missing and 0 values https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035834#M933465 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>You can try like this also .</P><P></P><P></P><P>Regards</P></BODY></HTML> Fri, 26 Feb 2016 09:33:23 GMT https://community.qlik.com/t5/QlikView/Show-only-missing-and-0-values/m-p/1035834#M933465 2016-02-26T09:33:23Z