5 Replies Latest reply: Mar 22, 2018 2:39 PM by Elizabeth Viso RSS

    Data Containing a Zero Clears out Other Data

    Elizabeth Viso

      Hello!

       

      I have an excel sheet that has data as "0" so when I pull it into Qlik it clears out other data attached to it. So my excel sheet has the Facility name as UHT and within that row, it has the column 14 as 0 which is correct. Now on QLik it pulls the data but shows me the Facility as "-". Now if I change the number on my excel sheet it will show me the facility name on Qlik. What could cause that? I have it allowing Null Values.

       

      Excel:

      Capture22.PNG

       

      Qlik:

       

      Qlik.PNG

       

      If anyone has any ideas why this his happening I would greatly appreciate it.

       

      Thank you!