Aggr() function

[#1]

Hi

Can anyone explain me how the Aggr() function works with beautiful example with data in different scenarios.

B'coz i'm getting confuse on this functionality. I've gone through the reference manual also..

[calvindk]

No you cannot use Aggr in the script. You will have to make do with group by.

[#3]

hey John and other experts,

liked ur inputs on Aggr fn, which explains a lot, here is one of the scenario m stck frm a long time,

m having 2 dimensions and 1 expression,

Branch

company

Sum

i need Branchwise  top 10 companies,

m using calculated dimension as =aggr(if(rank(sum(FST_LOAN_AMT)/Denominator)<=11, COMP_NAME),COMP_NAME)

whn i select specific branch, this exp works n i get top 10 comp for each branch ,

but whn i select date calender, it shows less records or it automatically eliminates some of the records,

anybody please help me out into this,

i know thr is some problem with the aggr function used.

Ur inputs are very valuable to me.....

[#4]

simple ideas make bg things .

[#5]

Hello guys,

Im trying to create an expression using the AGGR function.

The dimensions for the function however need to be flexible that's why I wanted to enter an object variable instead of mentioning the dimension explicitly. The object variable will then contain the dimension name.

current expression without variable would look like this:

AGGR(nodistinct SUM(Measure),Year)

Now since I want to change the level of aggregation from a yearly perspective to half yearly or monthly perspective, I would like to replace the dimension name with the variable. I tried a few examples like the following, but none of them worked.

AGGR(nodistinct SUM(Measure),$(varTime_Dimension))

Does anyone know how to correctly include the variable into the function (if possible at all)?

[#6]

Please help me.

I have exam data of a class of 50 students.

Now I want to calculate the average (and, median) of top 80% students of that class.

How can I do that?
Please help.

Thanks.

[jolivares]

I think the best way is to create a Satatistic Box.  And for control the 80% use the dimension limit tab.

[#8]

hi van anyone help me how to achieve the below one

networkid users timestamp

n1 u1 3.00

n2 u2 4.00

n3 u2 3.00

n4 u3 5.00

n1 u4 6.00

n2 u1 4.00

n3 u3 5.00

n4 u2 6.00

n1 u1 3.00

n2 u2 4.00

n3 u2 3.00

n4 u3 5.00

n1 u4 6.00

n2 u1 4.00

n3 u3 5.00

n4 u2 6.00

n4 u2 3.00

n4 u3 4.00

n2 u3 5.00

n1 u4 6.00

n2 u1 4.00

n3 u3 5.00

n4 u2 6.00

n1 u1 3.00

n2 u2 4.00

n3 u2 3.00

n4 u3 5.00

n3 u3 5.00

n4 u2 6.00

n1 u1 3.00

n2 u2 4.00

n3 u2 3.00

n4 u3 5.00

n1 u4 6.00

n2 u1 4.00

n3 u3 4.00

n4 u4 6.00

n4 u2 3.00

n4 u1 5.00

n2 u3 5.00

n1 u4 6.00

n2 u1 4.00

n1 u3 6.00

n2 u4 4.00

n1 u4 3.00

n2 u3 4.00

n4 u3 6.00

n4 u3 3.00

I want to get the count of those users who are at a place(networkid in my case) for more than 80% of time.

please help me through this

[Anonymous]

Hi, from what i understood from your post i made this, i hope it will help you.

BR,

CA

[#10]

hi,

i am not able to open your file as i had qlikview PE. can you please post your solutn in  a text doc r directly here

[Anonymous]

This gives you the total time(worktime) spent by a user on a netwok:

sum(worktime)

This gives you the total time spent by a user on a netwok in comparison to the total time:

sum(worktime)/sum(TOTAL worktime)

Any good?

BR,

CA