Excel column with a formula is showing as null in Qlik Sense visualizations
I am getting null values for the dates when I have an Excel document that has the date as a long form number(1.43E+12) so I create a new column and calculate the date stamp (=((K5+(-4*3600000))/86400000)+25569). The rows with the calculated fields show as in Qlik Sense. So when I sort by date these records are immediaely excluded. I copied my formula column in Excel and the pasted it as values and made sure the cell format was "date". However, it does not change what happens when I load it into Qlik Sense.
When I look at the Data Manager or the Data Model Viewer it shows the fields find and validates each row has a value. It is just when I put it into a visualization the value disappears.
Re: Excel column with a formula is showing as null in Qlik Sense visualizations
I appreciate you looking at it for me. I am using an enterprise version of Qlik Sense, not a local. Nevertheless, it is solved now, the dates now display correctly. I wanted to make sure there not something unique I needed to do, and apparently there wasn't anything.