Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Rahul,
May be, as in attached file?
Regards,
Andrey
Like this?
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
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
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
PFA