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.
If anyone has any ideas why this his happening I would greatly appreciate it.