topic Straight Table Null Issue in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46996#M7821 <HTML><HEAD></HEAD><BODY><P>I am using Qlik Sense. I&nbsp; have a Sales Order NO and Sum (Sales)&nbsp; Expression.&nbsp; When I list the Sales Order NO and Sales as a Dimension I can see all the values including the Nulls but as soon as I use Sum(Sales) . I get only rows with Values, it drops all the Null values, even though All value check box is checked.</P></BODY></HTML> Thu, 03 May 2018 02:43:01 GMT azmeerrehan 2018-05-03T02:43:01Z Straight Table Null Issue https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46996#M7821 <HTML><HEAD></HEAD><BODY><P>I am using Qlik Sense. I&nbsp; have a Sales Order NO and Sum (Sales)&nbsp; Expression.&nbsp; When I list the Sales Order NO and Sales as a Dimension I can see all the values including the Nulls but as soon as I use Sum(Sales) . I get only rows with Values, it drops all the Null values, even though All value check box is checked.</P></BODY></HTML> Thu, 03 May 2018 02:43:01 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46996#M7821 azmeerrehan 2018-05-03T02:43:01Z Re: Straight Table Null Issue https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46997#M7822 <HTML><HEAD></HEAD><BODY><P>Uncheck the Supress Zero values and try . Aggreation function will make the null value as 0 </P></BODY></HTML> Thu, 03 May 2018 04:14:48 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46997#M7822 qliksus 2018-05-03T04:14:48Z Re: Straight Table Null Issue https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46998#M7823 <HTML><HEAD></HEAD><BODY><P>Already unchecked, also I dont want to use AGGR </P></BODY></HTML> Thu, 03 May 2018 13:22:21 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Null-Issue/m-p/46998#M7823 azmeerrehan 2018-05-03T13:22:21Z