topic Set analysis usage ... think the expression code could be better ... i'm a little stuck in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-usage-think-the-expression-code-could-be-better-i-m/m-p/182418#M504380 <HTML><HEAD></HEAD><BODY><P>I have an expression but I'm sure there must be a better way of doing this ...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />= sum({$&lt; FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Factuur'}, Year ={$(vCurrentYear)},K.BBG = {'BINNENLAND'},K.KBG = {'KLANT'} &gt;} if(A.PGC &lt;&gt; 'AVM' or (A.PGC= 'AVM' and IsNull(V.FRNr)= 0), V.Number)) +<BR /> sum({$&lt;FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Order'}, Year ={$(vCurrentYear)}&gt;} V.Number)<BR /></PRE><BR /><BR /> <P>Maybe someone can help me make this better?</P><P>Thx in advance</P><P>Anita</P></BODY></HTML> Thu, 10 Dec 2009 15:18:06 GMT Anonymous 2009-12-10T15:18:06Z Set analysis usage ... think the expression code could be better ... i'm a little stuck https://community.qlik.com/t5/QlikView/Set-analysis-usage-think-the-expression-code-could-be-better-i-m/m-p/182418#M504380 <HTML><HEAD></HEAD><BODY><P>I have an expression but I'm sure there must be a better way of doing this ...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />= sum({$&lt; FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Factuur'}, Year ={$(vCurrentYear)},K.BBG = {'BINNENLAND'},K.KBG = {'KLANT'} &gt;} if(A.PGC &lt;&gt; 'AVM' or (A.PGC= 'AVM' and IsNull(V.FRNr)= 0), V.Number)) +<BR /> sum({$&lt;FB= {'Eigen'}, A.ACC={'TERMINAL'}, V.DT = {'Order'}, Year ={$(vCurrentYear)}&gt;} V.Number)<BR /></PRE><BR /><BR /> <P>Maybe someone can help me make this better?</P><P>Thx in advance</P><P>Anita</P></BODY></HTML> Thu, 10 Dec 2009 15:18:06 GMT https://community.qlik.com/t5/QlikView/Set-analysis-usage-think-the-expression-code-could-be-better-i-m/m-p/182418#M504380 Anonymous 2009-12-10T15:18:06Z