
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Missing field values after loading data
Hello,
I have an CSV-file that I want to load into my Qlik Sense App. When selecting the file and relevant fields I get to show values for those three fields:
As soon as I load the data, those values seem to disappear.
I tried it with and without transforming the data but the values are still empty. Does anyone have an idea why those field values get lost?
Thank you very much!
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I just saved the CSV-file as an XLSX-file and re-loaded the data. Now my values appear as shown in the original file... I actually have multiple CSV-files that I load into that specific app without any problems, it is just this one that seems to have a "bug". I will talk to my contact person to check the file and the field values. I guess the problem is located there...
I just thought that mabye it might have an answer to solve it in Qlik, so thank you for your support.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @vkal12
Do you have any selections on?
Is there Section Access applied to the document.
If you look in Selections, do you see any data there:
Where are you getting the second screenshot from, it doesn't look like a Sense table.
Steve

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Steve,
the second screenshot is from the datamodel view where I can select a table and have a preview at the bottom. There is no section access applied to the app, also there aren't any selections applied.
I just load the data as it is into the app and the values seem to disappear.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's very odd.
Is there a WHERE statement applied to the load?
In the datamodel view can you see the count of rows, does that have a positive value?
Steve

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No WHERE Statement. I just select the file from my folder, load it into the data load editor and then load the data without changing anything.
In my datamodel view it shows me the following:
My dataset only has 3 rows, all three of them are blank after loading the data but Qlik seems to recognize them as values, as it is not counting them as NULL-values.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you copy and paste your load script into the thread please?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is my load script:
I just grab the file from a specified path on our server. This is the output in the datamodel viewer.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I can't see anything that should be a problem there.
Seeing you have pasted a screenshot of all of the data in the file, would you mind sharing the file itself? I guess as you obfuscated the name in the screenshot you may want to rename it first.
Steve

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I just saved the CSV-file as an XLSX-file and re-loaded the data. Now my values appear as shown in the original file... I actually have multiple CSV-files that I load into that specific app without any problems, it is just this one that seems to have a "bug". I will talk to my contact person to check the file and the field values. I guess the problem is located there...
I just thought that mabye it might have an answer to solve it in Qlik, so thank you for your support.
