topic Re: RE:Null display in QlikView https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062638#M355550 <HTML><HEAD></HEAD><BODY><P>NULL is not a value, so I am not sure what you want to show in your chart.</P><P></P><P>Maybe the count of records with NULL?</P><P></P><P>=NullCount(Field)</P></BODY></HTML> Tue, 03 May 2016 10:58:32 GMT swuehl 2016-05-03T10:58:32Z RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062637#M355549 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I have a issue .</P><P></P><P>i have one filter like</P><P>Year</P><P>2000</P><P>2001</P><P>2002&nbsp;&nbsp; lik dat ..... and i have a bar chart .&nbsp;&nbsp; so my requirment is :</P><P></P><P>in that years i have&nbsp; some null values.&nbsp;&nbsp;&nbsp;&nbsp; so when i ever i clik on any year&nbsp; for that year null values should display on chart?</P><P></P><P></P><P>how can i do this?</P><P></P><P>Thanks in advance</P><P></P><P>Best</P><P>Chanty</P></BODY></HTML> Tue, 03 May 2016 10:56:03 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062637#M355549 Chanty4u 2016-05-03T10:56:03Z Re: RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062638#M355550 <HTML><HEAD></HEAD><BODY><P>NULL is not a value, so I am not sure what you want to show in your chart.</P><P></P><P>Maybe the count of records with NULL?</P><P></P><P>=NullCount(Field)</P></BODY></HTML> Tue, 03 May 2016 10:58:32 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062638#M355550 swuehl 2016-05-03T10:58:32Z Re: RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062639#M355551 <HTML><HEAD></HEAD><BODY><P>How can you display null values? You mean to display the count of Null value?</P><P></P><P>May be <STRONG>Year</STRONG> as dimension and <STRONG>NullCount(Value)</STRONG> as Expression?</P></BODY></HTML> Tue, 03 May 2016 10:58:48 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062639#M355551 sunny_talwar 2016-05-03T10:58:48Z Re: RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062640#M355552 <HTML><HEAD></HEAD><BODY><P>yes sunny....</P><P></P><P>but&nbsp; if i want show in Pivot or stright table ? how can i do this?</P></BODY></HTML> Tue, 03 May 2016 11:00:14 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062640#M355552 Chanty4u 2016-05-03T11:00:14Z Re: RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062641#M355553 <HTML><HEAD></HEAD><BODY><P>The same way as Stefan and I mentioned. Add an expression <STRONG>NullCount(Value) </STRONG>with year as your dimension and all other dimensions you may have</P></BODY></HTML> Tue, 03 May 2016 11:01:29 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062641#M355553 sunny_talwar 2016-05-03T11:01:29Z Re: RE:Null display https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062642#M355554 <HTML><HEAD></HEAD><BODY><P>thnku stefan and sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 May 2016 11:02:51 GMT https://community.qlik.com/t5/QlikView/RE-Null-display/m-p/1062642#M355554 Chanty4u 2016-05-03T11:02:51Z