topic Expr ? in QlikView https://community.qlik.com/t5/QlikView/Expr/m-p/728857#M261207 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This is mY Set Analyisi Expr..</P><P>I want to Write it in Back End Script...</P><P>please convert it...</P><P></P><P>=if(DR_CR='D',</P><P></P><P></P><P>sum(OPENING)+</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'D'}&gt;}TD_DOC_AMT)-</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'C'}&gt;}TD_DOC_AMT),</P><P></P><P></P><P></P><P></P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'D'}&gt;}TD_DOC_AMT)-</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'C'}&gt;}TD_DOC_AMT)-sum(OPENING))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 30 Oct 2014 02:25:03 GMT 2014-10-30T02:25:03Z Expr ? https://community.qlik.com/t5/QlikView/Expr/m-p/728857#M261207 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This is mY Set Analyisi Expr..</P><P>I want to Write it in Back End Script...</P><P>please convert it...</P><P></P><P>=if(DR_CR='D',</P><P></P><P></P><P>sum(OPENING)+</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'D'}&gt;}TD_DOC_AMT)-</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'C'}&gt;}TD_DOC_AMT),</P><P></P><P></P><P></P><P></P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'D'}&gt;}TD_DOC_AMT)-</P><P>sum({&lt;TD_DOC_DT={"&lt;=$(=max(TD_DOC_DT))"},TD_DOC_DT_Year=,TD_DOC_DT_Month=,TD_DOC_DRCR_FLAG={'C'}&gt;}TD_DOC_AMT)-sum(OPENING))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 30 Oct 2014 02:25:03 GMT https://community.qlik.com/t5/QlikView/Expr/m-p/728857#M261207 2014-10-30T02:25:03Z