Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Help with aggr

Hi,

I have a problem with the aggr function

I have the following chart:

aggr.png

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

  

MutualDiasPagoPP
28 De Octubre128,11
Mutual293
Mutual363

Any idea??

Thanks!

4 Replies
hrlinder
Honored Contributor

Re: Help with aggr

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?

Not applicable

Re: Help with aggr

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

hrlinder
Honored Contributor

Re: Help with aggr

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

MutualDiasPagoPP
28 De Octubre128,11

as Well as other "mutual values"

MVP
MVP

Re: Help with aggr

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 , .... )

Community Browser