Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ecolomer
Honored Contributor II

Problem with Aggr & Set Analysis

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) )

p_ctes.pngthe number of Customer

Tags (2)
1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Problem with Aggr & Set Analysis

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

6 Replies

Re: Problem with Aggr & Set Analysis

What are the expected numbers here?

ecolomer
Honored Contributor II

Re: Problem with Aggr & Set Analysis

Hi Sunny T,

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

ecolomer
Honored Contributor II

Re: Problem with Aggr & Set Analysis

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

This data por a selected line (ALB  ALBACETE

Attached you have an excel with detailed data

Re: Problem with Aggr & Set Analysis

Can you please post sample Application?

Life is so rich, and we need to respect to the life !!!
ecolomer
Honored Contributor II

Re: Problem with Aggr & Set Analysis

In the original post is a qv file

antoniotiman
Honored Contributor III

Re: Problem with Aggr & Set Analysis

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

Community Browser