topic Re: Ancora Set Analisys in QlikView

Ancora Set Analisys

Marcoimp — Wed, 17 Jun 2015 10:59:27 GMT

Ho un certo numero di clienti che hanno comprato il prodotto A, alcuni il prodotto B, altri sia il prodotto A che il B....

come faccio a contarli?

Solo A:

COUNT({<MyTstTipo={A}, Cliente-=P({<MyTstTipo={B}>} Cliente)>} DISTINCT Cliente)

Solo B:

COUNT({<MyTstTipo={B}, Cliente-=P({<MyTstTipo={A}>} Cliente)>} DISTINCT Cliente)

Giusto?

Ma per quelli che hanno comprato tutt'e due come si fa?

Re: Ancora Set Analisys

jduarte12 — Wed, 17 Jun 2015 11:08:47 GMT

Marco,

I manage to understand italian (latin language, like portuguese), but I do not speak/write italian, so my answer will be in english. I hope that's not a problem.

You may try:

COUNT({<MyTstTipo={A,B}, Cliente-=P({<MyTstTipo={A,B}>} Cliente)>} DISTINCT Cliente)

Best regards

Re: Ancora Set Analisys

jduarte12 — Wed, 17 Jun 2015 11:17:15 GMT

The set analysis I suggested before will return "A or B".

In order to get "A and B", it may be better to try:

COUNT({<MyTstTipo={B}, Cliente-=P({<MyTstTipo={A}>} Cliente)>*<MyTstTipo={A}, Cliente-=P({<MyTstTipo={B}>} Cliente)>} DISTINCT Cliente)

Re: Ancora Set Analisys

Marcoimp — Wed, 17 Jun 2015 12:24:37 GMT

No: in your example I will get 0, because I ask for Clients both with only "A" AND with only "B".... impossibile.

Re: Ancora Set Analisys

Marcoimp — Wed, 17 Jun 2015 12:31:45 GMT

I have some clients that purchased product "A" and some other product "B", some other purchased "A" and "B", how can I count them?

Only A:

COUNT({<MyTstTipo={A}, Cliente -=P({<MyTstTipo={B}>} Cliente)>} DISTINCT Cliente)

Only B:

COUNT({<MyTstTipo={B}, Cliente -=P({<MyTstTipo={A}>} Cliente)>} DISTINCT Cliente)

Is it right?

But how can I count who purchased both products?

Re: Ancora Set Analisys

Marcoimp — Wed, 17 Jun 2015 13:05:33 GMT

EUREKA!

Here the answer:

COUNT({<MyTstTipo={A}, Cliente =P({<MyTstTipo={B}>} Cliente)>} DISTINCT Cliente)

I.E.

Count every Client with MyTstTipo="A" that is in group of all clients with MyTstTipo="B"