Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lovepirogova
New Contributor

Counting text fields and displaying it on a chart

Hi.

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:

1) order date

2) email address

for now I'm stuck on this: count(if(customerEmail<>0,1,0)) but this not working. The data on the chart is incorrect.