9 Replies Latest reply: Jan 12, 2018 3:10 AM by Devarasu R RSS

    How to add 3 conditions in one expression in qlik sense.

    Akshada Samant

      Hi,

       

      I have a dataset like below:

       

      Policy NumberTypeTOTAL
      118190
      1811100
      1811100
      182115
      183115
      184125
      186180
      1881150
      1891250

       

      I have to include 3 below conditions in one expression.

      1. Sum of field Total

      2. Distinct of Policy Number

      3. Type = 1

       

      Like in above dataset, some policy number have same records with type 1 and so the total gets wrong so wanted to use all 3 below conditions.

       

      I was trying with some what below but it din't work.

      Sum( { <[TYPE] = {'1'},{<Distinct Policy_Number>}>} [TC_TOTAL]  )

       

      Kindly help me to get it as it is required for my project.

       

      Thanks in advance.