topic Re: Problem with set analysis in table in QlikView

Problem with set analysis in table

Mon, 15 Apr 2013 15:41:26 GMT

Hello,

I have a problem with a column in wich I am using set analysis. I attached an example with my problem.

I have two tables, "Epigrafes" and "Movimientos". Both are related by the column Cuenta.

What I need is to modify the expression of column "Total" in the table "Resultado" to display the sum of the amounts ("Importes") for column related FilaTotal.

Example:

This is what I need. Rows 3, 4 and 5 have to show the sum of row 5. And 6, 7, 8 and 9 rows the sum of row 9.

I've tried with the expression: =SUM({$<Epigrafe=,Orden={'=FilaTotal'}>}Importes)

but it doesn't works.

Can you help me?

Best regards,

Oscar Iglesias.

Re: Problem with set analysis in table

Mon, 15 Apr 2013 17:19:35 GMT

This solution is not valid, to use the "max" does not always return the correct value. If the amount change sign as deputy qvw that no longer works.

Some solution.

Re: Problem with set analysis in table

Tue, 16 Apr 2013 16:09:59 GMT

Hello,

Please try with this expression

=sum( total <FilaTotal> match(FilaTotal,Orden)*Importes)

you have to add in your chart the dimension FilaTotal, but you can hide the column if it is a problem

Regards,

Benoît

Re: Problem with set analysis in table

Wed, 17 Apr 2013 07:23:13 GMT

Thank you very much for your answer, it works.

Regards,

Oscar Iglesias.