1 Reply Latest reply: Dec 21, 2016 1:53 AM by Avinash R RSS

    scripting

    mahesh babu

      Hi All

       

      I had a [Main Table] in QVW using the Binary load

       

      I had two variables like vstart and vEnd  which are created in the Variable overview  i want to used this variable in script level

       

      return expression in my script was like this does it works  and if i change the date of this variable values  using calendar object does not works with out reloading the app please advice

       

      NoConcatenate

      Table_temp:

       

      Load Name,

        Hours,

          Year,

        Month,

        Week,

        Sum(HOURS) as total hours

             Resident [Main Table]

      where ('$(vStart)')<=Date>=('$(vEnd)')

           Group by Name ;


      Drop  table [Main Table];

      does it works  please advice

        • Re: scripting
          Avinash R

          syntax is wrong

          where Date>='$(vStart)' and Date<=('$(vEnd)')

           

           

          have you set the variables

          vStart and vEnd ?


          if you changing the variable in the front end and the to reduce the data you have reload !!!

          Or

          to filter the data add a condition in the set analysis or the expression as below

          if(Date>=vStart  and Date<=vEnd, sum())