Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Straigh table with set analysis

Hi!

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

img.png

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!

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi,

     Using the following expression

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

hope its help you.

Regards,

Iyyappan

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Hi,

     Using the following expression

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

hope its help you.

Regards,

Iyyappan

View solution in original post

Highlighted
Partner
Partner

Thanks lyyappan V!

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

Regards!