topic Re: conditional counting on table chart in App Development

conditional counting on table chart

yjin — Wed, 26 Jan 2022 17:24:54 GMT

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!

Re: conditional counting on table chart

MarcoWedel — Wed, 26 Jan 2022 17:47:48 GMT

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/ScriptPrefixes/Hierarchy.htm

Re: conditional counting on table chart

yjin — Wed, 26 Jan 2022 20:28:04 GMT

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 :

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