topic Ordered count in QlikView

Ordered count

Wed, 18 May 2011 15:11:33 GMT

Suppose I have the following table:

Data:

Load * Inline [

idContact, idNewsletter, Action

1, 1, C

1, 2, C

1, 3, O

1, 4, R

1, 5, R

1, 6, C

2, 2, O

2, 3, O

2, 4, R

2, 5, R

2, 6, O

3, 3, C

3, 4, C

3, 5, R

3, 6, O

4, 4, O

4, 5, R

4, 6, C

5, 4, C

5, 5, R

5, 6, C

];

I want to obtain a bar chart whose first bar counts the number of C's in the first newsletter of each contact, the second bar counts the number of C's in the second newsletter of each contact ecc. (but the first/second.. newsletter is different for each contact...)

Can anyone help me with this?

Thanks

Re: Relativized count

Thu, 19 May 2011 06:28:19 GMT

Do u need this:

Plz find the attachment below.

Re: Relativized count

Thu, 19 May 2011 07:26:42 GMT

Thanks, but that's not really what I need.

My chart should count in the first coulumn the clicks on the fisrt newsletter a contact has received. In the second, the second and so forth.

So in the example the first coulumn will count the clicks, if any, at idContact=1 and idNewsletter=1, idContact=2 and idNewsletter=2 (because the newsletter 2 is the first for contact 2), idContact=3 and idNewsletter=3 ... Then in the second column it count the clicks, if any, at idContact=1 and idNewsletter=2, idContact=2 and idNewsletter=3, idContact=3 and idNewsletter=4... The second newsletter received by each contact. And so forth .

Is it any clearer?

Thanks a lot!

Re: Relativized count

Anonymous — Thu, 19 May 2011 11:28:07 GMT

Hi.

Maybe this will help you.

Regards.

Oscarashi

Re: Relativized count

Thu, 19 May 2011 11:53:33 GMT

Not really. I think I should make use only of a calculated dimension which has the first newsletter of each contact, then the second newsletter of each contact and so forth. Then I hall calculate the number of C's.