topic Re: Table in QlikView https://community.qlik.com/t5/QlikView/Table/m-p/578895#M1100677 <HTML><HEAD></HEAD><BODY><P>I assume this is the field which contains the details like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Production.TotalDistance</SPAN></P><P></P><P></P><P>Try like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(isnull( Production.TotalDistance ) = -1, 'Zero KM', 0)</SPAN></P></BODY></HTML> Tue, 15 Apr 2014 11:28:34 GMT its_anandrjs 2014-04-15T11:28:34Z Table https://community.qlik.com/t5/QlikView/Table/m-p/578892#M1100674 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm making a pivot table for my trucks in qlikview. Now I want it to show me only the trucks that have no data in it.</P><P>You got 3 types</P><P>- Trucks that got km's and the boardcomputer registered</P><P>- Trucks that got 0 km's in the boardcomputer</P><P>- Trucks that have no data. Now these trucks I want qlikview to show me but how can I accomplish this?</P><P></P><P>Already got this expression set up but it isn't giving me the right result:</P><P>If(isnull(sum(Production.TotalDistance)), 'Zero KM', 0)</P><P></P><P>All suggestions are welcome!</P></BODY></HTML> Tue, 15 Apr 2014 11:21:32 GMT https://community.qlik.com/t5/QlikView/Table/m-p/578892#M1100674 2014-04-15T11:21:32Z Re: Table https://community.qlik.com/t5/QlikView/Table/m-p/578893#M1100675 <HTML><HEAD></HEAD><BODY><P>Can you provide some sample data?</P></BODY></HTML> Tue, 15 Apr 2014 11:23:40 GMT https://community.qlik.com/t5/QlikView/Table/m-p/578893#M1100675 MK_QSL 2014-04-15T11:23:40Z Re: Table https://community.qlik.com/t5/QlikView/Table/m-p/578894#M1100676 <HTML><HEAD></HEAD><BODY><P>You cannot select nulls directly in QlikView. </P><P>This blog by&nbsp; <A href="https://community.qlik.com/qlik-users/4003">Henric Cronström</A> shows how you can change nulls to another value that you can then select.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null">http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null</A></P></BODY></HTML> Tue, 15 Apr 2014 11:27:24 GMT https://community.qlik.com/t5/QlikView/Table/m-p/578894#M1100676 Colin-Albert 2014-04-15T11:27:24Z Re: Table https://community.qlik.com/t5/QlikView/Table/m-p/578895#M1100677 <HTML><HEAD></HEAD><BODY><P>I assume this is the field which contains the details like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Production.TotalDistance</SPAN></P><P></P><P></P><P>Try like</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(isnull( Production.TotalDistance ) = -1, 'Zero KM', 0)</SPAN></P></BODY></HTML> Tue, 15 Apr 2014 11:28:34 GMT https://community.qlik.com/t5/QlikView/Table/m-p/578895#M1100677 its_anandrjs 2014-04-15T11:28:34Z