topic Re: Counting date and empty cells to create pie or bar chart in QlikView https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772603#M274130 <HTML><HEAD></HEAD><BODY><P><BR />Thanks Rob! You saved the day!</P><P>Works perfectly!</P><UL><LI>Not Closed is my 'Empty'</LI><LI>NA is 'NA'</LI><LI>Closed is 'Date'</LI></UL><P>And I changed the 'Background Color' in the 'Expression' tab.</P><P><IMG alt="monthendclosing.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77469_monthendclosing.JPG" style="width: 620px; height: 469px;" /></P></BODY></HTML> Mon, 09 Feb 2015 20:44:53 GMT 2015-02-09T20:44:53Z Counting date and empty cells to create pie or bar chart https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772601#M274128 <HTML><HEAD></HEAD><BODY><P>Please help,</P><P>I will like to create a bar&nbsp; chart or pie chart that will count cells with "date" values, cells with "NA" values and "empty" cells.</P><P>Please refer to the image to help out here.</P><P>Thanks<IMG alt="datecompleted.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77447_datecompleted.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 09 Feb 2015 17:33:00 GMT https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772601#M274128 2015-02-09T17:33:00Z Re: Counting date and empty cells to create pie or bar chart https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772602#M274129 <HTML><HEAD></HEAD><BODY><P>You could use a Calculated Dimension like:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">=if(trim(DateCompleted)='', 'Empty'</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">,if(DateCompleted='NA', 'NA'</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">,'Date'</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">))</SPAN></P><P></P><P>and an Expression</P><P>=sum(1)</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com/" rel="nofollow">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com/" rel="nofollow">http://robwunderlich.com</A></P></BODY></HTML> Mon, 09 Feb 2015 17:46:39 GMT https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772602#M274129 rwunderlich 2015-02-09T17:46:39Z Re: Counting date and empty cells to create pie or bar chart https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772603#M274130 <HTML><HEAD></HEAD><BODY><P><BR />Thanks Rob! You saved the day!</P><P>Works perfectly!</P><UL><LI>Not Closed is my 'Empty'</LI><LI>NA is 'NA'</LI><LI>Closed is 'Date'</LI></UL><P>And I changed the 'Background Color' in the 'Expression' tab.</P><P><IMG alt="monthendclosing.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77469_monthendclosing.JPG" style="width: 620px; height: 469px;" /></P></BODY></HTML> Mon, 09 Feb 2015 20:44:53 GMT https://community.qlik.com/t5/QlikView/Counting-date-and-empty-cells-to-create-pie-or-bar-chart/m-p/772603#M274130 2015-02-09T20:44:53Z