8 Replies Latest reply: Sep 12, 2017 11:32 PM by Anil Babu Samineni RSS

    Creating Bucket in Qlikview Script

    Yuvraj Killedar

      Dear All,

       

      Currently stuck in a scenario where I have to implement following bucket:

       

      If (ABS(Budgeted – Actual))<0.25 AND Actual <0.25, THEN

       

      “Miscellaneous”;

       

      If Budgeted>0 AND Actual =0, THEN “Exhibit Not Yet Started”;

       

      If Budgeted =0 AND Actual>0, THEN search for the Budgeted Value in subsequent quarters of that particular year, if the Budgeted Value is found in other quarters Then “Preponed”, Else “Unbudgeted”;

       

      If Budgeted =0 AND Actual=0, THEN “No RM Cost –OH Allocated”;

       

      If Budgeted<Actual, THEN “Budget Exceeded”;

       

      If Budgeted>Actual, THEN “Exhibit Batch Ongoing/Positive Variance”;

        Else ERROR.


      Actual Values are coming from SAP at Month Year Level whereas Budget from Excel file at Quarter level.

       

      Analysis & Calculations are to be shown at Project, Year & Quarter level.

       

      Please find attached sample data.