4 Replies Latest reply: Jan 13, 2016 9:27 AM by Andy Weir RSS

    Sum  issue in KPI or Text object

    christian juillard

      Hi everybody

       

      I built an Qlik Sense App and faced a strange behaviour, but no doubt someone will highlight my misunderstanding

       

      Context

      My table has 50 records, 1 unique record by Id

      for each record, i add a flag value 0 or 1 according some other field interpretation

       

      when I use a KPI or TEXT object using sum(Flag)  I get 1

      if I use a count(disitnct Id)  I get 50

      When I select Flag = 1, and count(distinct Id)  I get 14 which is the number I should have  with sum(Flag)

       

      So I don't underrstand why sum(Flag) returns 1

       

      Any idea ?

       

      Chris