topic Re: Aggr function not working in QlikView

Aggr function not working

tracycrown — Sun, 20 Sep 2015 15:45:15 GMT

Dear all

They are 4 students taking English exam in 2012, I would like to show the exam result for Student A and Others (average of the class) .

I managed to show no. of students = 4 in Expression and result for Student A (89).

However :
1. I have problem to show 4 students in Dimension using Aggr function (1 now should be 4).
2. I have problem to compute average for the class (4 students).

Thank you

Tracy

Re: Aggr function not working

sunny_talwar — Sun, 20 Sep 2015 15:53:37 GMT

I am working with Personal edition of QlikView, would you be able to share the dimension and expression information you havein your application right now?

Re: Aggr function not working

hic — Sun, 20 Sep 2015 16:12:43 GMT

Why do you have "# of Students" as dimension? I can understand that you want number of students as measure - but as dimension? You want the numbers per Year and Subject and these should be your dimensions.

If you still want it as dimension, you should add a total qualifier in the aggregation, e.g. count({1} total <Name>)

Finally, I suggest you don't use the all qualifier in your expression. It is a legacy function that we will remove in coming versions. Use count({1} total <Name> Seq) instead.

HIC

Re: Aggr function not working

petter — Sun, 20 Sep 2015 16:15:32 GMT

#Students in Dimension: Aggr(Count( {<Name=>} Seq) , Year, Subject )

#Students in Expression: Count(TOTAL <Year,Subject> {1} Seq)

Others in Expression: Avg( {<Name=>} Data)

ALL should be avoided and is equivalent to TOTAL {1}. Qlik points out that ALL is deprecated and might be removed as a valid keyword in any new release of QlikView.

Re: Aggr function not working

tracycrown — Sun, 20 Sep 2015 23:55:23 GMT

Dear Petter

Many thanks for your clear advice with examples.

Can you kindly explain what is {1} and the purpose in the 2nd statement ?.

Tracy

Re: Aggr function not working

sunny_talwar — Mon, 21 Sep 2015 03:24:40 GMT

{1} is used when you don't want your expression to change based on any selection you make in your application.

Re: Aggr function not working

tracycrown — Mon, 21 Sep 2015 04:13:47 GMT

Dear Sunny

Thanks for your quick response.

Tracy