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!