Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm currently working on developing an application in Qlik Sense where i have a dataset composed by ParentID, ChildID and other fields.
I'm stuck trying to make a chart with the distribution of number of parents with N childs, where the X-Axys would be the number of childs ( 0, 1, 2, 3, >3) and the Y-Axys would be the volume of parents.
I've searched the forums and the web but couldn't find any material that could help me doing that.
Do you guys have any sugestions of how can I make this?
Thankfull for any help
Perhaps something along the lines of:
Dimension - =Aggr(Count(distinct ChildID),ParentID)
Measure - Count(distinct ParentID)
I'm not sure if that's exactly it, but it should point you in the right direction at least.
Perhaps something along the lines of:
Dimension - =Aggr(Count(distinct ChildID),ParentID)
Measure - Count(distinct ParentID)
I'm not sure if that's exactly it, but it should point you in the right direction at least.
It did work! I hadn't thought of the Aggr function. Thanks for the tip