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



      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 ?