topic Show even if no records in QlikView https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482068#M1128325 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>In a straight table how can I get it show all records within a dimension even if there are no records under a certain selection.&nbsp; For example my dimension is Products and in a certain week one of the products was not sold but I still want it to show in the table.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 13 Dec 2013 16:01:45 GMT Anonymous 2013-12-13T16:01:45Z Show even if no records https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482068#M1128325 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>In a straight table how can I get it show all records within a dimension even if there are no records under a certain selection.&nbsp; For example my dimension is Products and in a certain week one of the products was not sold but I still want it to show in the table.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 13 Dec 2013 16:01:45 GMT https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482068#M1128325 Anonymous 2013-12-13T16:01:45Z Re: Show even if no records https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482069#M1128326 <HTML><HEAD></HEAD><BODY><P>Try adding an additional expression to the straight table with set analysis to evaluate all sales (e.g. sum( {1} Sales)) then hiding the column (option in presentation tab).</P></BODY></HTML> Fri, 13 Dec 2013 16:10:14 GMT https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482069#M1128326 rachael_selman 2013-12-13T16:10:14Z Re: Show even if no records https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482070#M1128327 <HTML><HEAD></HEAD><BODY><P>Thank you Rachael</P></BODY></HTML> Fri, 13 Dec 2013 16:21:06 GMT https://community.qlik.com/t5/QlikView/Show-even-if-no-records/m-p/482070#M1128327 Anonymous 2013-12-13T16:21:06Z