topic How to put this into set analysis (Urgent) in QlikView https://community.qlik.com/t5/QlikView/How-to-put-this-into-set-analysis-Urgent/m-p/316173#M116651 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #0000f0; font-size: 10pt;"></SPAN></P><P>IF PLANSTATUS = 3 OR PLANSTATUS = 12 OR PLANSTATUS = 13 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; 0;</P><P>&nbsp; ELSE </P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF PLANSTATUS = 6 OR PLANSTATUS = 8 OR PLANSTATUS = 9 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; PAYERSHARECV;</P><P>&nbsp;&nbsp;&nbsp; ELSE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF USDCOST &lt;&gt; 0 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; ROUND(USDCOST * GET_CONVERSIONRATE(1,POLICYCURRID,TRANSDATE),2);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV := PAYERSHARECV;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; END IF;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; END IF;</P><P></P><P></P><P></P><P>Help me Out Guys</P><P></P><P>Regards,</P><P>Venkatesh Salla</P></BODY></HTML> Mon, 30 Jan 2012 09:20:32 GMT 2012-01-30T09:20:32Z How to put this into set analysis (Urgent) https://community.qlik.com/t5/QlikView/How-to-put-this-into-set-analysis-Urgent/m-p/316173#M116651 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #0000f0; font-size: 10pt;"></SPAN></P><P>IF PLANSTATUS = 3 OR PLANSTATUS = 12 OR PLANSTATUS = 13 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; 0;</P><P>&nbsp; ELSE </P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF PLANSTATUS = 6 OR PLANSTATUS = 8 OR PLANSTATUS = 9 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; PAYERSHARECV;</P><P>&nbsp;&nbsp;&nbsp; ELSE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF USDCOST &lt;&gt; 0 THEN</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV :=&nbsp; ROUND(USDCOST * GET_CONVERSIONRATE(1,POLICYCURRID,TRANSDATE),2);</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PLANPAYERSHARECV := PAYERSHARECV;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END IF;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; END IF;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; END IF;</P><P></P><P></P><P></P><P>Help me Out Guys</P><P></P><P>Regards,</P><P>Venkatesh Salla</P></BODY></HTML> Mon, 30 Jan 2012 09:20:32 GMT https://community.qlik.com/t5/QlikView/How-to-put-this-into-set-analysis-Urgent/m-p/316173#M116651 2012-01-30T09:20:32Z