topic How to include data that has no transactions in QlikView https://community.qlik.com/t5/QlikView/How-to-include-data-that-has-no-transactions/m-p/297418#M1184031 <HTML><HEAD></HEAD><BODY><P>I want to analyse how much all new customers in the last month have spent. My problem is, if a customer has bought nothing they will not show up. What do i set to "show all" when the answer is zero or nil?</P></BODY></HTML> Wed, 14 Dec 2011 05:27:35 GMT 2011-12-14T05:27:35Z How to include data that has no transactions https://community.qlik.com/t5/QlikView/How-to-include-data-that-has-no-transactions/m-p/297418#M1184031 <HTML><HEAD></HEAD><BODY><P>I want to analyse how much all new customers in the last month have spent. My problem is, if a customer has bought nothing they will not show up. What do i set to "show all" when the answer is zero or nil?</P></BODY></HTML> Wed, 14 Dec 2011 05:27:35 GMT https://community.qlik.com/t5/QlikView/How-to-include-data-that-has-no-transactions/m-p/297418#M1184031 2011-12-14T05:27:35Z How to include data that has no transactions https://community.qlik.com/t5/QlikView/How-to-include-data-that-has-no-transactions/m-p/297419#M1184032 <HTML><HEAD></HEAD><BODY><P> Hey,</P><P></P><P>therefore you have to uncheck for every dimension "hide zero values" at the dimensions tab. Maybe you have also check "show all values".</P><P></P><P>regards</P></BODY></HTML> Wed, 14 Dec 2011 06:44:14 GMT https://community.qlik.com/t5/QlikView/How-to-include-data-that-has-no-transactions/m-p/297419#M1184032 2011-12-14T06:44:14Z