topic Re: Show Result on Parent Row in QlikView

Show Result on Parent Row

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Show Result on Parent Row

ahaahaaha — Tue, 11 Apr 2017 07:36:54 GMT

Hi Rahul,

May be, as in attached file?

Regards,

Andrey

Re: Show Result on Parent Row

tresB — Tue, 11 Apr 2017 07:40:55 GMT

Like this?

Re: Show Result on Parent Row

Anil_Babu_Samineni — Tue, 11 Apr 2017 07:42:13 GMT

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

Re: Show Result on Parent Row

Tue, 11 Apr 2017 08:00:04 GMT

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

Re: Show Result on Parent Row

Tue, 11 Apr 2017 08:01:51 GMT

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

Re: Show Result on Parent Row

tresB — Tue, 11 Apr 2017 08:47:04 GMT

PFA