topic Re: Double aggr () in QlikView

Double aggr ()

Thu, 29 Jan 2015 10:41:09 GMT

Hi All

I really need your help!

I have the following aggr in a pivot table:

aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)

The result is an ID number, lets say 2345.

this ID number, Is a key for additional field. lets say under this ID i have 3 "activities_children_id" (example: 2,5,7).

I want to count the number of "activities_children_id" under the result of the above aggr.

I tried to write the following expression:

aggr(count(activities_children_id),aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id))

but I received a null value and not the required result (3).

Can someone please advise?

thanks!

Attached an example

PrashantSangle — Thu, 29 Jan 2015 10:46:53 GMT

Hi,

Try with Only()

Try like,

aggr(count(activities_children_id),Only(aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)))

Regards

Anonymous — Thu, 29 Jan 2015 10:50:20 GMT

Hi,

Please can you upload sample data.

Regards

Neetha

Thu, 29 Jan 2015 11:58:31 GMT

thank you for answering.

I Try to use the expression above but It didn't work. In the text box I get "Error in expression: Nested aggregation not allowed"

PrashantSangle — Thu, 29 Jan 2015 12:01:00 GMT

Hi,

Create Variable with 1st aggr

and used that variable in your 2nd aggr()

Regards

Thu, 29 Jan 2015 12:05:47 GMT

Hi,

thanks.

that didn't helped also.. I get '-'

jmmayoral3 — Thu, 29 Jan 2015 12:22:41 GMT

Try this

Count({$< Activities_id = {'= aggr(max({<INDEX_Activitiy={"ABC"}>} Activities_id),Activities_ancestor_id)'} >} activities_children_id)