Empty rows from Excel get loaded into Qlik Sense or QlikViewArticle Number: 000045779 | Last Modified: 2019/01/24
However, if the empty row contains hidden formats Qlik or Qlikview will interpret any format as loadable content.
In this example row 4 has an empty data set.
Under normal circumstances Qlik Sense or QlikView will not load the empty rows by default.
But in Cell A4 there is a Currency Format applied, which is not obvious by just looking at the pure data.
This results that the empty row gets loaded in Qlik Sense or QlikView as Null data.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.