How to use Count with Two Criteria as Dimension

Wed, 11 Dec 2013 23:36:13 GMT

HI,

I have data structured like this

Recipient	Action	Valid	Date
emailAddress1@noemail.com	RECEIVED	1	01/01/2013
emailAddress1@noemail.com	OPENED	1	01/01/2013
emailAddress2@noemail.com	RECEIVED	1	01/02/2013
emailAddress2@noemail.com	RECEIVED	1	02/01/2013
emailAddress2@noemail.com	OPENED	1	04/02/2013
emailAddress2@noemail.com	CLICKED	0	05/01/2013
emailAddress5@noemail.com	RECEIVED	0	05/01/2013

My hope is to make a bar chart that will have the number of emails received (Action=Received & Valid=1) as the Dimension on the X axis and the number of Recipients on the Y axis as the expression, This way I can see how many people received 1, 2,3...N email.

I tried this with no luck as the dimension: =count({<Valid={'1'},Action={'RECEIVED'}>} Recipient)

many thanks

Re: How to use Count with Two Criteria as Dimension

maxgro — Thu, 12 Dec 2013 00:27:39 GMT

if I understand your question, try this

dimension

aggr(count(if(Valid=1 and Action='RECEIVED', Action)), Recipient)

measure

count(distinct if(Valid=1 and Action='RECEIVED', Recipient))

topic Re: How to use Count with Two Criteria as Dimension in QlikView

How to use Count with Two Criteria as Dimension

Re: How to use Count with Two Criteria as Dimension