topic Missing data in QlikView https://community.qlik.com/t5/QlikView/Missing-data/m-p/352746#M493442 <HTML><HEAD></HEAD><BODY><P>In the Load script you could do something like this:</P><P></P><P>if(len(trim(Sales))&lt;&gt;0,sales,'0.00') as sales</P></BODY></HTML> Tue, 15 May 2012 20:46:48 GMT goldnejea8 2012-05-15T20:46:48Z Missing data https://community.qlik.com/t5/QlikView/Missing-data/m-p/352745#M493441 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please have a look at the attached image. I need to make surethat all the stores for the selected retailer are always visible. The problem Ihave is when all products have not been sold in a particular store, then thatstore would not be listed in the pivot table as there is no data for thecurrent selection.</P><P>How can I always display all the stores for a selectedretailer regardless of if it had sales or any other selections?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 15 May 2012 19:38:36 GMT https://community.qlik.com/t5/QlikView/Missing-data/m-p/352745#M493441 2012-05-15T19:38:36Z Missing data https://community.qlik.com/t5/QlikView/Missing-data/m-p/352746#M493442 <HTML><HEAD></HEAD><BODY><P>In the Load script you could do something like this:</P><P></P><P>if(len(trim(Sales))&lt;&gt;0,sales,'0.00') as sales</P></BODY></HTML> Tue, 15 May 2012 20:46:48 GMT https://community.qlik.com/t5/QlikView/Missing-data/m-p/352746#M493442 goldnejea8 2012-05-15T20:46:48Z