topic Please help!!! in QlikView https://community.qlik.com/t5/QlikView/Please-help/m-p/977835#M644066 <HTML><HEAD></HEAD><BODY><P>abc:</P><P>load count(Product) as no_of_prod </P><P>Resident SalesTable where Product='asdf' group by Product;</P><P></P><P>if there is zero record, why table abc doesn't show one record as '0'?</P></BODY></HTML> Wed, 09 Dec 2015 09:42:34 GMT 2015-12-09T09:42:34Z Please help!!! https://community.qlik.com/t5/QlikView/Please-help/m-p/977835#M644066 <HTML><HEAD></HEAD><BODY><P>abc:</P><P>load count(Product) as no_of_prod </P><P>Resident SalesTable where Product='asdf' group by Product;</P><P></P><P>if there is zero record, why table abc doesn't show one record as '0'?</P></BODY></HTML> Wed, 09 Dec 2015 09:42:34 GMT https://community.qlik.com/t5/QlikView/Please-help/m-p/977835#M644066 2015-12-09T09:42:34Z