topic Re: Ultimate Parent Status \ Top in Hierarchy Status \ Status for Category by Sub category in App Development https://community.qlik.com/t5/App-Development/Ultimate-Parent-Status-Top-in-Hierarchy-Status-Status-for/m-p/2030816#M84904 <P>Try</P> <P>Count({&lt;ChildStatus={Open}&gt;} distinct Parent)</P> Fri, 27 Jan 2023 12:15:51 GMT hic 2023-01-27T12:15:51Z Ultimate Parent Status \ Top in Hierarchy Status \ Status for Category by Sub category https://community.qlik.com/t5/App-Development/Ultimate-Parent-Status-Top-in-Hierarchy-Status-Status-for/m-p/2029763#M84830 <P>Hi All,<BR /><BR />I need to find the status for the Parent ID considering all child ID. If any of of the Child is in Open status then parent Status should be Open else closed. And count of the total Open Parents. Below is the sample data.&nbsp;</P> <TABLE width="399"> <TBODY> <TR> <TD width="64">Parent</TD> <TD width="83">Child</TD> <TD width="74">Depth</TD> <TD width="95">ChildStatus</TD> <TD width="83"><FONT color="#993366"><EM><STRONG>ParentStatus</STRONG></EM></FONT></TD> </TR> <TR> <TD>1</TD> <TD>1</TD> <TD>1</TD> <TD>Open</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2</TD> <TD>2A</TD> <TD>3</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Closed</STRONG></EM></FONT></TD> </TR> <TR> <TD>2</TD> <TD>2B</TD> <TD>3</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Closed</STRONG></EM></FONT></TD> </TR> <TR> <TD>2</TD> <TD>2C</TD> <TD>3</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Closed</STRONG></EM></FONT></TD> </TR> <TR> <TD>3</TD> <TD>3A</TD> <TD>2</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> <TR> <TD>3</TD> <TD>3B</TD> <TD>2</TD> <TD>Open</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> <TR> <TD>4</TD> <TD>4</TD> <TD>1</TD> <TD>Closed</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>5</TD> <TD>5A</TD> <TD>4</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> <TR> <TD>5</TD> <TD>5B</TD> <TD>4</TD> <TD>Open</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> <TR> <TD>5</TD> <TD>5C</TD> <TD>4</TD> <TD>Closed</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> <TR> <TD>5</TD> <TD>5D</TD> <TD>4</TD> <TD>Open</TD> <TD><FONT color="#993366"><EM><STRONG>Open</STRONG></EM></FONT></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>The count of open parent will 2 as only Parent 3 and 5 have the Open status.</P> <TABLE width="135"> <TBODY> <TR> <TD width="135">CountOfOpen Parent</TD> </TR> <TR> <TD>2</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Thank You,<BR />Md Irfan</P> Wed, 25 Jan 2023 09:46:34 GMT https://community.qlik.com/t5/App-Development/Ultimate-Parent-Status-Top-in-Hierarchy-Status-Status-for/m-p/2029763#M84830 Md_Irfan 2023-01-25T09:46:34Z Re: Ultimate Parent Status \ Top in Hierarchy Status \ Status for Category by Sub category https://community.qlik.com/t5/App-Development/Ultimate-Parent-Status-Top-in-Hierarchy-Status-Status-for/m-p/2030816#M84904 <P>Try</P> <P>Count({&lt;ChildStatus={Open}&gt;} distinct Parent)</P> Fri, 27 Jan 2023 12:15:51 GMT https://community.qlik.com/t5/App-Development/Ultimate-Parent-Status-Top-in-Hierarchy-Status-Status-for/m-p/2030816#M84904 hic 2023-01-27T12:15:51Z