Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master II
Master 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

1 Solution

Accepted Solutions
Master III
Master III

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

View solution in original post

6 Replies

What are the expected numbers here?

Master II
Master II

Hi Sunny T,

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

Master II
Master II

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

Can you please post sample Application?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Master II
Master II

In the original post is a qv file

Master III
Master III

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

View solution in original post