topic Counting text fields and displaying it on a chart in QlikView https://community.qlik.com/t5/QlikView/Counting-text-fields-and-displaying-it-on-a-chart/m-p/1423117#M513112 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I need to compare amount of customers with and without an email. In our database email parameter can be email address, or empty. The result should be displayed on a bar chart. Data that seems to me useful:</P><P>1) order date</P><P>2) email address</P><P></P><P>for now I'm stuck on this: count(if(customerEmail&lt;&gt;0,1,0)) but this not working. The data on the chart is incorrect.</P></BODY></HTML> Tue, 24 Oct 2017 13:48:56 GMT Anonymous 2017-10-24T13:48:56Z Counting text fields and displaying it on a chart https://community.qlik.com/t5/QlikView/Counting-text-fields-and-displaying-it-on-a-chart/m-p/1423117#M513112 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I need to compare amount of customers with and without an email. In our database email parameter can be email address, or empty. The result should be displayed on a bar chart. Data that seems to me useful:</P><P>1) order date</P><P>2) email address</P><P></P><P>for now I'm stuck on this: count(if(customerEmail&lt;&gt;0,1,0)) but this not working. The data on the chart is incorrect.</P></BODY></HTML> Tue, 24 Oct 2017 13:48:56 GMT https://community.qlik.com/t5/QlikView/Counting-text-fields-and-displaying-it-on-a-chart/m-p/1423117#M513112 Anonymous 2017-10-24T13:48:56Z