8 Replies Latest reply: Jul 24, 2017 5:51 AM by Jose Miguel Vilaplana Pascual RSS

    Qlik Duplicating Values

    Alison Cooke

      Hello Everyone,

       

      Some field values are duplicating when they are added into Qlik.

       

      For example,

       

      I have raw data that looks like so:   

      Item

      Q1 Budget

      Study Room Program Manager6000
      Study Room Assistant1800
      Rent0
      Utilities1200
      Generator Expenses300
      Phonebills & Internet Expenses125
      Professional Fees - Lawyer & Auditor1250
      Stationary128
      Public School Supervisors0
      Printing12000
      Revision & Consulting0
      Marketing & Advertising0
      Web Fees (Social Media)1000
      Study Room Furniture (Two Class rooms & accessories)0
      Equipment (Required for bigger premises)

      0

       

       

      But for some reason, when uploaded to Qlik, the values are duplicated.

      Screenshot (55).png

       

      Why is that? I know I can solve the issue using distinct i.e. Sum(distinct [Quarter One Budget]). But I am curious as to why this is happening. Please can someone explain this to me.

       

      Thank you in advance,

      Alison