11 Replies Latest reply: Nov 17, 2016 11:07 AM by Zhihong He RSS

    How to write script regular statement

    Jet Yang

      I want to add a field "promotion" in QlikSense.

       

      The Data source form connected to the SQL Server, and not this field, it is necessary to filter out the database from the required, as a new field "promotion"

       

      The SQLQuery  is

       

      SELECT Max(IndexValue),CASE_NO,Subject

      FROM [Members_Report_DYN_Batch] Where GroupName='MarketIndex'

      GROUP BY CASE_NO,IndexValue,Subject

       

      So how do I write the script regular statements?


      Thanks in advance for any help!