topic Straigh table with set analysis in QlikView

Straigh table with set analysis

julruiz123 — Tue, 27 Mar 2012 03:56:34 GMT

Hi!

In the next two tables there's a relation with the field "Agrupador"

I need to create a straight table that shows for each year and month the "Facturación" value and "Data" value.

Ejm:

Agrupador Año Mes Facturación Data

ARP 2011 jul $87.916.239,28 211,12

How i can do that with set analysis.

I need to do something like that:

=Sum({$<[Año Presupuesto]=Año, [Mes Presupuesto]=Mes>}Data)

Thanks!

v_iyyappan — Tue, 27 Mar 2012 05:40:55 GMT

Hi,

Using the following expression

=Sum({<Año ={$(=Max(Año))},Mes={$(=Max(Mes))}>}Data)

hope its help you.

Regards,

Iyyappan

julruiz123 — Wed, 28 Mar 2012 20:11:47 GMT

Thanks lyyappan V!

I used in this way, just i added a condition if there isn't a selection.

Regards!