topic Re: Aggr function in QlikView

Aggr function

hari8088 — Tue, 29 Jul 2014 05:23:15 GMT

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.

Re: Aggr function

tresB — Tue, 29 Jul 2014 05:24:35 GMT

QlikView Technical Brief - AGGR.docx

Re: Aggr function

avinashelite — Tue, 29 Jul 2014 05:26:06 GMT

Hi Hari,

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

Re: Aggr function

VishalWaghole — Tue, 29 Jul 2014 05:30:00 GMT

Hi hari,

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

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

-- Regards,

Vishal Waghole

Re: Aggr function

warrentk80 — Tue, 29 Jul 2014 07:41:20 GMT

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

Re: Aggr function

hari8088 — Wed, 30 Jul 2014 11:20:42 GMT

Thank you Andrea

I understand the function