Set analysis Aggr

[pgalvezt]

Hello,

Can you help me with this syntaxis:

Aggr(sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor,Familia) Thrown null.

Thanks!

[Clever_Anjos]

You need another aggregation function depeding what you want

max(Aggr(sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor,Familia) )

avg(Aggr(sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor,Familia) )

[Gysbert_Wassenaar]

Is Valor_Factor a field name or a variable? If it's a field you can get nulls if a value from the dimension Familia has several different Valor-Factor values. Perhaps you need something like Aggr(sum({<Cuenta={'31010101'}>}Monto*-1 /Valor_Factor),Familia). And as cleveranjos says you may have to add an aggregation function like max, avg or sum around your current expression.

[pgalvezt]

Hello,

Thank you for your answers,

Still give Null. I've tried this because QlikView Show a different sum when export to excel. I put January like Example

Can you help me with this?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[pgalvezt]

Hi,

Gysbert I had already that formula.What I want is to get the first result (358..).

Thanks!

[Gysbert_Wassenaar]

In that case, please do explain what you want. Posting a document that contains the result you say you want is confusing. If you already have the result then why post the question?

If you want the value 358961245 displayed in a text box then get rid of the aggr: sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor

[pgalvezt]

Hi,

Sorry maybe I explained very bad the case Sorry about that

My formula sum({<Cuenta={'31010101'}>}Monto*-1) /Valor_Factor Works fine with many views and sheets. But with some graphs does´t work the real result is 358961245. QlikView show that result (But When I export Excel the sume Gives 721677934. What I want is the real sum in excel 358961245. I hope you can understand the case...

Thanks!

[Gysbert_Wassenaar]

Well, then you need to buy a new Excel . Yours is broken. If I export your table to Excel the subtotal 358961245 is exported to excel too. If I manually add a sum formula in excel to sum the values of the rows I get 721677934 of course, because those values that are summed do in fact sum up to a total of 721677934

[pgalvezt]

Hi,

Are you sure??? I did the sum with a calculator (Watching QlikView) And get 721677934. I Think I left to add an aggregation to my formula until get 358961245 (Dimenssions). But I Still I can not get the real result. With your formula QlikView Shows 721677934. I' ve been moving the dimension inside the formula. If I change the dimension to vendor (Vendedor) Works. But by family (Familia) I don´t know why thrown another result.

Thanks!