topic Re: Help with aggr in QlikView

Help with aggr

Mon, 31 Aug 2015 20:25:21 GMT

Hi,

I have a problem with the aggr function

I have the following chart:

where

DíasPagoPP = (suM(ImportePago)/sum(total ImportePago)) * (only(FechaPago)-only(FechaPresentacion))

I need a table only with the dimention: Mutual and the expresion DiasPagoPP

Any idea??

Thanks!

Anonymous — Mon, 31 Aug 2015 20:31:39 GMT

if you Need the other expressions for calcualting, you may hide These expressions

(only possible if you use straight table)

what is Mutual2 and Mutual3?

Mon, 31 Aug 2015 20:46:19 GMT

thanks Rudolf for your quickly response.

I need to create a new chart only with de dimension Mutual and de expresion DiasPagoPP to compare the "DiasPagoPP" by Mutual...

Mutual2 and Mutual3 are fake names of Mutual. I used only as example.

Thanks again

Anonymous — Mon, 31 Aug 2015 20:54:09 GMT

I am not sure if I understood correct?

WHat if you define a new table (or Chart) just with the Dimension Mutual and the expression

DíasPagoPP = (suM(ImportePago)/sum(total ImportePago)) * (only(FechaPago)-only(FechaPresentacion))

you should get 1 line for your example above with

Mutual	DiasPagoPP
28 De Octubre	128,11

as Well as other "mutual values"

petter — Mon, 31 Aug 2015 21:03:46 GMT

Usually you wrap the expression in an Aggr and add the excluded dimensions into the Aggr() function as parameter 2, 3 and more if necessary.

Aggr( <your-aggregate-expression-goes-here> , Dimension2, Dimension3 , .... )