conditional counting on table chart

[yjin]

I have tabular data like:

Name	ID	ChildOf
A	1
B	2	1
C	3
D	4	1
E	5
F	6	3

and I would like to present it as table chart as follow:

Name	Count
A	2
C	1

What's the correct set modifier or method to achieve this?  Thank you!

[MarcoWedel]

maybe you could load this data as a hierarchy so your expressions become less complex than they would be given your current data model:
https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[yjin]

Hi @MarcoWedel , that's (using load scripts) certainly a possibility, but I am trying to see if I can do this using just chart functions alone.  Also note this isn't really a hierarchy - at least, I don't want to present it and get answer this way.  I am trying to see :

1. if I can use another field value as filtering condition for a count.  E.g., something like : count({1<ChildOf={ID}>}ID)
2. filter out / hide rows with count = 0 (or other conditions) in table chart (and without introducing additional column in table chart)