Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

0 Replies