topic Re: how to use nested set analysis in QlikView https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101150#M903199 <HTML><HEAD></HEAD><BODY><P>Good afternoon Mahi,</P><P></P><P>Use something like this:</P><P>=sum ( { $ &lt; Region={'abc'},Territory={'def'},account={'ghi'}, [BU level]={'jkl'} &gt; } Sales)</P><P></P><P>See for more information: <A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P></BODY></HTML> Wed, 06 Jul 2016 14:24:22 GMT jharke 2016-07-06T14:24:22Z how to use nested set analysis https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101149#M903198 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I have a Scenario anyone can please help me.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> when total of sales are to generated at region, Territory, account and BU level (Nested Set Analysis)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P></P><P>Many Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101149#M903198 2020-11-25T16:16:04Z Re: how to use nested set analysis https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101150#M903199 <HTML><HEAD></HEAD><BODY><P>Good afternoon Mahi,</P><P></P><P>Use something like this:</P><P>=sum ( { $ &lt; Region={'abc'},Territory={'def'},account={'ghi'}, [BU level]={'jkl'} &gt; } Sales)</P><P></P><P>See for more information: <A href="https://community.qlik.com/docs/DOC-4951">Set Analysis: syntaxes, examples</A></P></BODY></HTML> Wed, 06 Jul 2016 14:24:22 GMT https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101150#M903199 jharke 2016-07-06T14:24:22Z Re: how to use nested set analysis https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101151#M903200 <HTML><HEAD></HEAD><BODY><P>Not sure I understand your requirement, would you be able to elaborate?</P></BODY></HTML> Wed, 06 Jul 2016 15:39:58 GMT https://community.qlik.com/t5/QlikView/how-to-use-nested-set-analysis/m-p/1101151#M903200 sunny_talwar 2016-07-06T15:39:58Z