topic Re: Problem with Aggr & Set Analysis in QlikView

Problem with Aggr & Set Analysis

ecolomer — Fri, 29 Jul 2016 04:55:38 GMT

Hi,

I need to obtain in a table with (Ventas) Sales >0 in the Actual Year and the same for the last Year and but my expression don't work.

count({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} distinct Cliente)
Sum(if(Aggr(Sum({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} imVentaTAM), Cliente)>0, 1,0) )

the number of Customer

Re: Problem with Aggr & Set Analysis

sunny_talwar — Fri, 29 Jul 2016 05:03:33 GMT

What are the expected numbers here?

Re: Problem with Aggr & Set Analysis

ecolomer — Fri, 29 Jul 2016 06:34:34 GMT

Hi Sunny T,

Attached I send a excel file with the list customers and marked error in column

Re: Problem with Aggr & Set Analysis

ecolomer — Fri, 29 Jul 2016 22:04:32 GMT

For Nº Clientes 2016 = 111 (no 120) and for Nº Clientes 2015 = 119 (is OK)

This data por a selected line (ALB ALBACETE

Attached you have an excel with detailed data

Re: Problem with Aggr & Set Analysis

Anil_Babu_Samineni — Sat, 30 Jul 2016 07:54:29 GMT

Can you please post sample Application?

Re: Problem with Aggr & Set Analysis

ecolomer — Sat, 30 Jul 2016 08:25:37 GMT

In the original post is a qv file

Re: Problem with Aggr & Set Analysis

antoniotiman — Sat, 30 Jul 2016 08:32:13 GMT

Hi Enrique,

In Your Doc I tried

count({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'},Cliente={"=Sum({<Año={$(AñoActual)}, Mes={'<=$(MesActual)'}>} imVentaTAM) > 0"}>} distinct Cliente)

The result is 111

Regards,

Antonio