Show Result on Parent Row

[#1]

Hi All,

i am facing the issue as below.

Simple data as:

CoL1	CoL2	CoL3	Result
Parent1	Activity1	Parent1
Child1	Activity2	Parent1
Child2	Activity3	Parent1	5
Child3	Activity4	Parent1
Child4	Activity5	Parent1

here i want to count the number of Activities performed on Parent+Child, and the result will be display on Parent row only. which is not happening above. for above problem i written expression for result as :

AGGR(Distinct Count([CoL2]),[COL3])

Expected result will be :

CoL1	CoL2	CoL3	Result
Parent1	Activity1	Parent1	5
Child1	Activity2	Parent1
Child2	Activity3	Parent1
Child3	Activity4	Parent1
Child4	Activity5	Parent1

Is there a way to display the count for Parent row only not for Child.

OR is their any other way to get this expect AGGR?

[NOTE: i am using the Qlik Sense 2.2 edition]

I hope I made myself clear.

Thanks,

Rahul

[OmarBenSalem]

Maybe like this?

if(CoL1='Parent1',AGGR(Distinct Count([CoL2]),CoL3))

[sunny_talwar · Accepted solution]

Or may be this:

If(Col1 = Col3, Count(DISTINCT TOTAL <Col3> Col2))

[OmarBenSalem]

I would go with Sunny's expression which work with all the next 'Parents' values. While mine is rather static.