2 Replies Latest reply: Jan 17, 2018 1:26 PM by pradosh thakur RSS

    How to give count distinct statement in qlik sense load script editor in qlik sense ?

    Nupur Gupta

      hi ,

      how to give the following query in load editor script  what are the terms to be used both in LOAD and SELECT statement -


      SELECT "acc_period",

      "hospital",

      "nationality",

      "patient_type",

      "admit_status",

      COUNT(DISTINCT episode_seq) AS COUNT

      FROM "table name"

      GROUP BY "acc_period","hospital","nationality","patient_type","admit_status" ;