topic Set Analysis Problem in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Problem/m-p/1010055#M968117 <HTML><HEAD></HEAD><BODY><P>I want to convert this below expression into a set expression:</P><P></P><P>(sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER and DATE_KEY&lt;=DATE AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))-sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY&lt;=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0)))/<BR />sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY&lt;=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))*100</P><P></P><P>Can anyone help me on this?</P><P></P><P>Thanks in Advance</P><P>Asif</P></BODY></HTML> Wed, 23 Sep 2015 13:26:46 GMT asifmaula2015 2015-09-23T13:26:46Z Set Analysis Problem https://community.qlik.com/t5/QlikView/Set-Analysis-Problem/m-p/1010055#M968117 <HTML><HEAD></HEAD><BODY><P>I want to convert this below expression into a set expression:</P><P></P><P>(sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER and DATE_KEY&lt;=DATE AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))-sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY&lt;=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0)))/<BR />sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY&lt;=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))*100</P><P></P><P>Can anyone help me on this?</P><P></P><P>Thanks in Advance</P><P>Asif</P></BODY></HTML> Wed, 23 Sep 2015 13:26:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Problem/m-p/1010055#M968117 asifmaula2015 2015-09-23T13:26:46Z