Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to put this into set analysis (Urgent)

Hi

IF PLANSTATUS = 3 OR PLANSTATUS = 12 OR PLANSTATUS = 13 THEN

     PLANPAYERSHARECV :=  0;

  ELSE

     IF PLANSTATUS = 6 OR PLANSTATUS = 8 OR PLANSTATUS = 9 THEN

        PLANPAYERSHARECV :=  PAYERSHARECV;

    ELSE

         IF USDCOST <> 0 THEN

            PLANPAYERSHARECV :=  ROUND(USDCOST * GET_CONVERSIONRATE(1,POLICYCURRID,TRANSDATE),2);

      ELSE

            PLANPAYERSHARECV := PAYERSHARECV;

      END IF;

     END IF;   

  END IF;

Help me Out Guys

Regards,

Venkatesh Salla

0 Replies