https://community.qlik.com/t5/Integration-Extension-APIs/Flop-5-with-NULL-values/m-p/1590972#M10745 <P>Hello,</P><P>I wanted to create a table with the flop 5 customer.<BR />They all have a turnover but some of them turnover has got null values as their turnover. Surely the flop 5 Customers are the ones without a value but I want to generate a table without these null values.</P><P>Now the problem is that I can´t restrict the turnover &gt;0 and generate the flop 5 customer at the same time.</P><P>Has someone an idea to solve these problem?</P><P>Thank you</P><P>Christina</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:36:42 GMT CSchoene 2024-11-16T05:36:42Z https://community.qlik.com/t5/Integration-Extension-APIs/Flop-5-with-NULL-values/m-p/1590972#M10745 <P>Hello,</P><P>I wanted to create a table with the flop 5 customer.<BR />They all have a turnover but some of them turnover has got null values as their turnover. Surely the flop 5 Customers are the ones without a value but I want to generate a table without these null values.</P><P>Now the problem is that I can´t restrict the turnover &gt;0 and generate the flop 5 customer at the same time.</P><P>Has someone an idea to solve these problem?</P><P>Thank you</P><P>Christina</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:36:42 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Flop-5-with-NULL-values/m-p/1590972#M10745 CSchoene 2024-11-16T05:36:42Z https://community.qlik.com/t5/Integration-Extension-APIs/Flop-5-with-NULL-values/m-p/1591301#M10751 <P>try to make preceding load&nbsp;</P><P>load * where value&gt;0</P> Thu, 13 Jun 2019 01:17:36 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Flop-5-with-NULL-values/m-p/1591301#M10751 Channa 2019-06-13T01:17:36Z