Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Result on Parent Row

Hi All,

i am facing the issue as below.

Simple data as:

 

CoL1CoL2CoL3Result
Parent1Activity1Parent1
Child1Activity2Parent1
Child2Activity3Parent15
Child3Activity4Parent1
Child4Activity5Parent1


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 :

CoL1CoL2CoL3Result
Parent1Activity1Parent1 5
Child1Activity2Parent1
Child2Activity3Parent1
Child3Activity4Parent1
Child4Activity5Parent1

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

6 Replies
ahaahaaha
Master
Master

Hi Rahul,

May be, as in attached file?

Regards,

Andrey

tresesco
MVP
MVP

Like this?

Capture.PNG

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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

Not applicable
Author

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
MVP
MVP

PFA