topic Ignoring Table row (TOTAL) but using value in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Ignoring-Table-row-TOTAL-but-using-value-in-Set-Analysis/m-p/1157725#M377514 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>related to my earlier question over <A href="https://community.qlik.com/thread/229627">here </A>I got a follow-up question:</P><P></P><P>In a straight table containing my root elements (cf. linked question with the great solution .qvw by Stefan) I need to display a column with the number of elements below this root.</P><P></P><P>Displaying this value by selecting root element and using a TextObject with the following expression works fine:</P><P style="padding-left: 30px;"><STRONG>= COUNT({1&lt;PID2 = P(NodeID)&gt;} DISTINCT <SPAN style="font-size: 13.3333px;">NodeID</SPAN>)</STRONG></P><P></P><P>However, within the straight table this does not work, as I need to leave the scope of the current single row (to get to the other elements being related to the root). Therefore, I tried using <STRONG>TOTAL</STRONG>, but then <SPAN style="font-size: 13.3333px;">NodeID in my Set Analysis is not anymore the current row's NodeID.</SPAN></P><P></P><P>Is there a way to use TOTAL but still be able to use the NodeID of the respective row in the Set Analysis?</P><P></P><P>Any help is highly appreciated!</P></BODY></HTML> Tue, 23 Aug 2016 13:14:49 GMT 2016-08-23T13:14:49Z Ignoring Table row (TOTAL) but using value in Set Analysis https://community.qlik.com/t5/QlikView/Ignoring-Table-row-TOTAL-but-using-value-in-Set-Analysis/m-p/1157725#M377514 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>related to my earlier question over <A href="https://community.qlik.com/thread/229627">here </A>I got a follow-up question:</P><P></P><P>In a straight table containing my root elements (cf. linked question with the great solution .qvw by Stefan) I need to display a column with the number of elements below this root.</P><P></P><P>Displaying this value by selecting root element and using a TextObject with the following expression works fine:</P><P style="padding-left: 30px;"><STRONG>= COUNT({1&lt;PID2 = P(NodeID)&gt;} DISTINCT <SPAN style="font-size: 13.3333px;">NodeID</SPAN>)</STRONG></P><P></P><P>However, within the straight table this does not work, as I need to leave the scope of the current single row (to get to the other elements being related to the root). Therefore, I tried using <STRONG>TOTAL</STRONG>, but then <SPAN style="font-size: 13.3333px;">NodeID in my Set Analysis is not anymore the current row's NodeID.</SPAN></P><P></P><P>Is there a way to use TOTAL but still be able to use the NodeID of the respective row in the Set Analysis?</P><P></P><P>Any help is highly appreciated!</P></BODY></HTML> Tue, 23 Aug 2016 13:14:49 GMT https://community.qlik.com/t5/QlikView/Ignoring-Table-row-TOTAL-but-using-value-in-Set-Analysis/m-p/1157725#M377514 2016-08-23T13:14:49Z