topic Re: Show dimension when expression value is null in QlikView https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818922#M533988 <HTML><HEAD></HEAD><BODY><P>=if(isnull(sales),0, sales)</P></BODY></HTML> Tue, 03 Mar 2015 07:11:45 GMT 2015-03-03T07:11:45Z Show dimension when expression value is null https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818921#M533987 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">I have a straight table where I am simply showing sum of sales for the days of the week.&nbsp; If there are no sales for a day of the week, like Monday, how can I force that day to appear with no data or zero?</SPAN></P><P></P><P><SPAN style="font-size: 14pt;">Thank you!</SPAN></P><P><SPAN style="font-size: 14pt;">Robyn</SPAN></P><P></P><P>Sun&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>Mon&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Tues&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>Wed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>Thurs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>Fri&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>Sat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22</P></BODY></HTML> Mon, 02 Mar 2015 21:46:39 GMT https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818921#M533987 2015-03-02T21:46:39Z Re: Show dimension when expression value is null https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818922#M533988 <HTML><HEAD></HEAD><BODY><P>=if(isnull(sales),0, sales)</P></BODY></HTML> Tue, 03 Mar 2015 07:11:45 GMT https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818922#M533988 2015-03-03T07:11:45Z Re: Show dimension when expression value is null https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818923#M533989 <HTML><HEAD></HEAD><BODY><P>Deselect "<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Suppress when value is null"</SPAN> i<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">n Presentation tab</SPAN></P></BODY></HTML> Tue, 03 Mar 2015 07:17:47 GMT https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818923#M533989 anbu1984 2015-03-03T07:17:47Z Re: Show dimension when expression value is null https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818924#M533990 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Create Master Calendar to solve the issue.</P><P></P><P>Regards</P></BODY></HTML> Tue, 03 Mar 2015 07:18:33 GMT https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818924#M533990 PrashantSangle 2015-03-03T07:18:33Z Re: Show dimension when expression value is null https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818925#M533991 <HTML><HEAD></HEAD><BODY><P>Robyn,</P><P></P><P>In dimensions tab:</P><P>- check "show all values"</P><P>- uncheck "supress when value is null"</P><P></P><P>In presentation tab:</P><P>- uncheck "supress zero values"</P><P></P><P></P><P>Marc.</P></BODY></HTML> Tue, 03 Mar 2015 07:19:19 GMT https://community.qlik.com/t5/QlikView/Show-dimension-when-expression-value-is-null/m-p/818925#M533991 Anonymous 2015-03-03T07:19:19Z