problem "aggr" function with drill down group

[Anonymous]

Hi folks,

I would like to have a table (pivot or straight table) to display results using the "aggr" funtion and a drill down group.

Expression:  = avg(aggr(avg(SalesOrderDetail.OrderQty), GetCurrentField(Geography)))

where "Geography" is the Drill down Group.

This does not work and shows "-" as result.

If I use  "GetCurrentField(Geography)" in a text box or the header of a table it shows correctly the selected

drill down group

When I create two tables and use the expression explicitly, it works like I want it.

    Expression: =avg(aggr(avg(SalesOrderDetail.OrderQty), CustomerTerritory.SalesTerritory.Group))

Is there any chance to have a single table?

Regards

Rudolf

[brenner_martina · Accepted solution]

Hi,

I tried it in my tables, it is working fine with the list of dimensions you have in your group like:

avg(aggr(avg(SalesOrderDetail.OrderQty),Groupfield1,Groupfield2,Groupfield3,...))

Greetings from Munich

[kaushalview]

Hi

Can u sen me ur application

Regrads

Kaushal Mehta

[Anonymous]

Hi Martina,

thanks for your answer. It works like you mentioned. But when I compar the values they are not correct.
(as this is the task for the certification) I could verify with the validation report.

I tried the use of a variable (Variable = getcurrentfield(Geography)

with "avg(aggr(avg(SalesOrderDetail.OrderQty),Variable)"  in expression.

With that I get the same results as in the validation report.

Any idea why with your solution I get the wrong numbers?

Thanks for your help!

Greetings from Boeblingen

[#5]

Hi, HRLinder. You say (as this is the task for the certification) . And where can I find these tasks? I was looking for any materials and information to be able to prepare for QlikView Certification (Developer or Designer), but didn't succeed. Thanks in advance for help