topic formula in hierarchy in QlikView https://community.qlik.com/t5/QlikView/formula-in-hierarchy/m-p/215371#M68835 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I use a hierarchy, and have a pivot table and staright table in my application.<BR />the dimensions of this pivot table are 3 fields from the hierarchy<BR />I need to create an expression that checks another expresion, and decides which calculation to make.<BR />this check needs to be done only if Depth&gt;=3, if Depth&lt;3 I need to display the sum of lower level (no matter what the another expression is)<BR /><BR />I'm not sure if this can be done @QV, but that's my requirements....</P><P>Any thoughts?</P><P>Thanks,</P><P>Nitza</P></BODY></HTML> Mon, 14 Feb 2011 16:16:50 GMT 2011-02-14T16:16:50Z formula in hierarchy https://community.qlik.com/t5/QlikView/formula-in-hierarchy/m-p/215371#M68835 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I use a hierarchy, and have a pivot table and staright table in my application.<BR />the dimensions of this pivot table are 3 fields from the hierarchy<BR />I need to create an expression that checks another expresion, and decides which calculation to make.<BR />this check needs to be done only if Depth&gt;=3, if Depth&lt;3 I need to display the sum of lower level (no matter what the another expression is)<BR /><BR />I'm not sure if this can be done @QV, but that's my requirements....</P><P>Any thoughts?</P><P>Thanks,</P><P>Nitza</P></BODY></HTML> Mon, 14 Feb 2011 16:16:50 GMT https://community.qlik.com/t5/QlikView/formula-in-hierarchy/m-p/215371#M68835 2011-02-14T16:16:50Z formula in hierarchy https://community.qlik.com/t5/QlikView/formula-in-hierarchy/m-p/215372#M68836 <HTML><HEAD></HEAD><BODY><P>Hello are you aware that you can create variables within QV?</P><P>Create your other expression as a variable and then use it against your current expression in a chart.</P><P></P></BODY></HTML> Mon, 14 Feb 2011 16:19:24 GMT https://community.qlik.com/t5/QlikView/formula-in-hierarchy/m-p/215372#M68836 2011-02-14T16:19:24Z