topic problem "aggr" function with drill down group in QlikView

problem "aggr" function with drill down group

Anonymous — Mon, 09 May 2011 08:25:07 GMT

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

problem "aggr" function with drill down group

brenner_martina — Mon, 09 May 2011 09:21:54 GMT

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

problem "aggr" function with drill down group

kaushalview — Mon, 09 May 2011 10:18:22 GMT

Can u sen me ur application

Regrads

Kaushal Mehta

problem "aggr" function with drill down group

Anonymous — Mon, 09 May 2011 11:58:38 GMT

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

problem "aggr" function with drill down group

Thu, 02 Feb 2012 11:28:40 GMT

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