topic Load Calculation - converting set analysis formula in QlikView https://community.qlik.com/t5/QlikView/Load-Calculation-converting-set-analysis-formula/m-p/204130#M61167 <HTML><HEAD></HEAD><BODY><P>Hi, I would like to do the following calculationg during load. However, I don't think we can do set analysis during load. The calculation is summing up REV (revenue) based on start and expiry date of the contract substracted by the REP (repairs) based on start and expiry date.</P><P>Thanks a bunch!</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />sum( {$&lt;TranDate={'&gt;=$(=(min(GM_START)))&lt;=$(=(max(GM_EXP)))'}&gt;} REV )<BR />- sum( {$&lt;TranDate={'&gt;=$(=(min(GM_START)))&lt;=$(=(max(GM_EXP)))'}&gt;} REP ) as profit<BR /></PRE><BR /><BR /> <P>your friendly neighborhood noob,</P><P>Chhai.</P></BODY></HTML> Thu, 07 Jan 2010 14:41:52 GMT 2010-01-07T14:41:52Z Load Calculation - converting set analysis formula https://community.qlik.com/t5/QlikView/Load-Calculation-converting-set-analysis-formula/m-p/204130#M61167 <HTML><HEAD></HEAD><BODY><P>Hi, I would like to do the following calculationg during load. However, I don't think we can do set analysis during load. The calculation is summing up REV (revenue) based on start and expiry date of the contract substracted by the REP (repairs) based on start and expiry date.</P><P>Thanks a bunch!</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />sum( {$&lt;TranDate={'&gt;=$(=(min(GM_START)))&lt;=$(=(max(GM_EXP)))'}&gt;} REV )<BR />- sum( {$&lt;TranDate={'&gt;=$(=(min(GM_START)))&lt;=$(=(max(GM_EXP)))'}&gt;} REP ) as profit<BR /></PRE><BR /><BR /> <P>your friendly neighborhood noob,</P><P>Chhai.</P></BODY></HTML> Thu, 07 Jan 2010 14:41:52 GMT https://community.qlik.com/t5/QlikView/Load-Calculation-converting-set-analysis-formula/m-p/204130#M61167 2010-01-07T14:41:52Z