topic Does not show NULL in dimension in QlikView https://community.qlik.com/t5/QlikView/Does-not-show-NULL-in-dimension/m-p/269838#M101198 <HTML><HEAD></HEAD><BODY><P>How I can create IF clause that shows only their names witch is not NULL&nbsp; in the table dimension.</P></BODY></HTML> Mon, 11 Jul 2011 07:15:40 GMT 2011-07-11T07:15:40Z Does not show NULL in dimension https://community.qlik.com/t5/QlikView/Does-not-show-NULL-in-dimension/m-p/269838#M101198 <HTML><HEAD></HEAD><BODY><P>How I can create IF clause that shows only their names witch is not NULL&nbsp; in the table dimension.</P></BODY></HTML> Mon, 11 Jul 2011 07:15:40 GMT https://community.qlik.com/t5/QlikView/Does-not-show-NULL-in-dimension/m-p/269838#M101198 2011-07-11T07:15:40Z Does not show NULL in dimension https://community.qlik.com/t5/QlikView/Does-not-show-NULL-in-dimension/m-p/269839#M101199 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; No need to use any If statement.</P><P></P><P>&nbsp;&nbsp; Just click on the Dimension and look at the bottom for setting which says,</P><P></P><P>&nbsp;&nbsp;&nbsp; Suppress When Value is Null.</P><P></P><P>&nbsp;&nbsp; Check that option.</P><P></P><P>&nbsp;&nbsp; Thats it.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 11 Jul 2011 07:17:46 GMT https://community.qlik.com/t5/QlikView/Does-not-show-NULL-in-dimension/m-p/269839#M101199 kaushiknsolanki 2011-07-11T07:17:46Z