topic KPI Tree - Multiple Dimension having each different expression in App Development https://community.qlik.com/t5/App-Development/KPI-Tree-Multiple-Dimension-having-each-different-expression/m-p/1794775#M62277 <P>Hi,</P><P>I want to show KPI tree as below table or if any suggestion how can we give the drill down option or any visualization views.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Level 0</STRONG></TD><TD><STRONG>Level 1</STRONG></TD><TD><STRONG>Level 2</STRONG></TD><TD><STRONG>Level 3</STRONG></TD><TD><STRONG>Level 4</STRONG></TD><TD><STRONG>Level 5</STRONG></TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A111</TD><TD>PRS</TD><TD>123</TD><TD>98U</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A112</TD><TD>PRS</TD><TD>678</TD><TD>TFX</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A113</TD><TD>POW</TD><TD>R4T</TD><TD>GHT</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A114</TD><TD>POW</TD><TD>T5Y</TD><TD>BFR</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A123</TD><TD>ZOP</TD><TD>KIL</TD><TD>BGH</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A123</TD><TD>WEN</TD><TD>LOP</TD><TD>H76</TD></TR><TR><TD>ABC</TD><TD>PQR</TD><TD>LMN</TD><TD>EFH</TD><TD>SWD</TD><TD>PLK</TD></TR><TR><TD>ABC</TD><TD>PQR</TD><TD>GHW</TD><TD>APO</TD><TD>CDE</TD><TD>RST</TD></TR><TR><TD>ABC</TD><TD>DEF</TD><TD>WED</TD><TD>SUN</TD><TD>MAN</TD><TD>PYU</TD></TR><TR><TD>ABC</TD><TD>DEF</TD><TD>DEW</TD><TD>STR</TD><TD>REN</TD><TD>KAN</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>For each Level there is different expression, so how do I achieve it, I tried using Nested If but its not working.</P><P>or any chart or any suggestion to achieve it.</P><P>&nbsp;</P><P>Thank You in advance</P><P>&nbsp;</P><P>Any suggestions pls</P> Sat, 16 Nov 2024 00:21:54 GMT renuka_sasikuma 2024-11-16T00:21:54Z KPI Tree - Multiple Dimension having each different expression https://community.qlik.com/t5/App-Development/KPI-Tree-Multiple-Dimension-having-each-different-expression/m-p/1794775#M62277 <P>Hi,</P><P>I want to show KPI tree as below table or if any suggestion how can we give the drill down option or any visualization views.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><STRONG>Level 0</STRONG></TD><TD><STRONG>Level 1</STRONG></TD><TD><STRONG>Level 2</STRONG></TD><TD><STRONG>Level 3</STRONG></TD><TD><STRONG>Level 4</STRONG></TD><TD><STRONG>Level 5</STRONG></TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A111</TD><TD>PRS</TD><TD>123</TD><TD>98U</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A112</TD><TD>PRS</TD><TD>678</TD><TD>TFX</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A113</TD><TD>POW</TD><TD>R4T</TD><TD>GHT</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A114</TD><TD>POW</TD><TD>T5Y</TD><TD>BFR</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A123</TD><TD>ZOP</TD><TD>KIL</TD><TD>BGH</TD></TR><TR><TD>ABC</TD><TD>XYZ</TD><TD>A123</TD><TD>WEN</TD><TD>LOP</TD><TD>H76</TD></TR><TR><TD>ABC</TD><TD>PQR</TD><TD>LMN</TD><TD>EFH</TD><TD>SWD</TD><TD>PLK</TD></TR><TR><TD>ABC</TD><TD>PQR</TD><TD>GHW</TD><TD>APO</TD><TD>CDE</TD><TD>RST</TD></TR><TR><TD>ABC</TD><TD>DEF</TD><TD>WED</TD><TD>SUN</TD><TD>MAN</TD><TD>PYU</TD></TR><TR><TD>ABC</TD><TD>DEF</TD><TD>DEW</TD><TD>STR</TD><TD>REN</TD><TD>KAN</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>For each Level there is different expression, so how do I achieve it, I tried using Nested If but its not working.</P><P>or any chart or any suggestion to achieve it.</P><P>&nbsp;</P><P>Thank You in advance</P><P>&nbsp;</P><P>Any suggestions pls</P> Sat, 16 Nov 2024 00:21:54 GMT https://community.qlik.com/t5/App-Development/KPI-Tree-Multiple-Dimension-having-each-different-expression/m-p/1794775#M62277 renuka_sasikuma 2024-11-16T00:21:54Z