7 Replies Latest reply: Oct 10, 2011 5:22 AM by Anand Chouhan RSS

    Simple Script with SET keyword

      Hi ,

      can anyone tell what is the error with the following script.I am not getting the expected result..

       

       

      SET currentYear=2002;

       

      Budget:

      LOAD Office,

      Year,

      [Budget rev.],

      [Budget cost],

      [Actual rev.],

      [Actual cost]

      FROM D:\Applns\Soumya\Qlikview\Qlikview_practices\xls-qlk\Budget.xls (biff, embedded labels, table is Sheet1$);

       

      Budget_new:

      LOAD Office,[Budget rev.],Year RESIDENT Budget where Year=$(currentYear);

       

       

      Thanks in advance