Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am loading data via flat excel files and Qlik Sense is limiting the number of rows that are loaded.
I have a calendar count table with 126438 rows but Qlik Sense is only loading the data up to row 123050. I have no filters on in Qlik Sense.
IssueID | Date | OPEN_COUNT | CLOSED_COUNT | ACCEPTED_COUNT |
1 | 2017-12-06 10:25:58 | 1 | 0 | 0 |
1 | 2018-01-08 06:00:17 | 0 | 1 | 0 |
2 | 2018-01-08 06:00:16 | 1 | 0 | 0 |
2 | 2018-03-23 09:30:07 | 0 | 1 | 0 |
3 | 2018-01-08 06:00:16 | 1 | 0 | 0 |
3 | 2018-02-08 06:02:52 | 0 | 1 | 0 |
Any help would be greatly appreciated.
Thanks,
Joseph
What excel format is the file? if you save the file to csv, does it work as expected?
What excel format is the file? if you save the file to csv, does it work as expected?
That worked like a charm. I changed the file type to csv, reloaded it and i am bringing in my full row count now.
Thank you for the quick response and help!