Aggr function

[hari8088]

Hi

    What is the use of aggr function and how it will work. please give me the solution for this and the functionality of aggr function

       Thanks in advance.

[tresesco]

QlikView Technical Brief - AGGR.docx

[avinashelite]

Hi Hari,

Please refer this community link Aggr() function and document given by tresesco

[VishalWaghole]

Hi hari,

Find link given below, which is good example of Aggr function.

www.learnallbi.com/aggr-function-in-qlikview/

-- Regards,

Vishal Waghole

[warrentk80]

Hello the works AGGR allows you to enter in the expression of clusters

if you have to make an average or a relationship between two measures of the total it is different from it on a aggregation of another field

in Annex I send you a sample

the example I have a field with the relationship between 2 measures (m1/m2)

SUM (m1/m2) calculates the sum of M1 and M2 and then makes the relationship

AGGR (SUM (m1/m2), customer) for each customer is the ratio of the sum of m1 and m2) and then sum the result of each customer.

As you can see, the result is different.

I hope I was clear of possibly sending the file QV.

Let me know

Thank you

Andrea

[hari8088]

Thank you Andrea

I understand the function