I recently needed to clean up a data set to load all nulls as zeros, that I figured out, but I have a different excel file that for some reason is loading 0's in the places where there are blanks. I have double checked and indeed the cells are blank, yet my load displays 0s for those fields.
I don't want to convert all 0s to null, I just need the blank cells to be null or blank. Is there something I can add in the load editor to keep them blank or some other trick to do so?
Thanks for getting back to me! I have since discovered that the data is stored as null, the problem was in my calculation. I have since figured out that I my aggregated sum was creating the 0. So I am only half crazy ...of course Qlik Sense was correct! 🤣
