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;



      LOAD Office,


      [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$);



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



      Thanks in advance