Convert if expression into set analysis expression

Wed, 19 Aug 2015 06:40:50 GMT

Dear Experts,

Help required to convert into if Expression into Set analysis. Expression follows as....

=((SUM(if(COEP.BUDAT_PRW >=v_FyFirstDate AND COEP.BUDAT_PRW <=v_CUREENT_DATE,COEP.MENGE1_PRW))

       -
              SUM(IF(VERSN_PRW=vBudget_Version AND ZDATE_PRW >= v_FyFirstDate AndZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))
              )
              *
              if (IsNull((SUM(IF(VERSN_PRW=vBudget_Version AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_VALPRW * MDCL_QTY_PRW )))
                           /(SUM(IF(VERSN_PRW=vBudget_Version AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))
                           )),0,
                           (SUM(IF(VERSN_PRW=vBudget_Version AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_VALPRW * MDCL_QTY_PRW )))
                           /(SUM(IF(VERSN_PRW=vBudget_Version AND ZDATE_PRW >=v_FyFirstDate And ZDATE_PRW1 <= v_CUREENT_DATE , LIKELY_QTYPRW*MDCL_QTY_PRW))
                           ))
              )
              /amt

Re: Convert if expression into set analysis expression

sasiparupudi1 — Wed, 19 Aug 2015 08:05:27 GMT

please try the following 2 expressions(first 2 lines in your formula) in a texbox and see if they return you the correct values

sum({<COEP.BUDAT_PRW={">=$(=$(v_FyFirstDate)) <=$(=$(v_CUREENT_DATE))"}>}COEP.MENGE1_PRW)

sum({<VERSN_PRW={"$(=$(vBudget_Version))"},ZDATE_PRW={">=$(=$(v_FyFirstDate)) <=$(=$(v_CUREENT_DATE))"}>} (LIKELY_QTYPRW*MDCL_QTY_PRW))

topic Convert if expression into set analysis expression in QlikView

Convert if expression into set analysis expression

Re: Convert if expression into set analysis expression