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?

I hope I made myself clear.

Thanks,

Rahul

[ahaahaaha]

Hi Rahul,

May be, as in attached file?

Regards,

Andrey

[tresesco]

Like this?

[Anil_Babu_Samineni]

You can use this for result -- Aggr(Count(TOTAL CoL2),CoL3)

And then call Suppress Zero-Values and then place Null Symbol as Space. It will work

[#5]

Hi Tresesco,

Thanks a lot,

But unfortunately i am using the Qlik Sense 2.2 enterprise edition. hence can you please send me  .qvf file or guide how to open the .qvw file in QlikSense ?

Rahul

[#6]

Hi Andrey,

Thanks for your help.

however i am using the Qlik Sense 2.2 enterprise edition. hence can you please send me  .qvf file or guide how to open the .qvw file in QlikSense ?

Rahul

[tresesco]

PFA