Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
KingVegi
Contributor II
Contributor II

First 1000 gives correct values, all data gives null values

Hello everyone!!

So I'm trying to format the contents of a field into a Date but when I load the script, it returns null in the frontend. The weird thing is not exactly the returning of null values, but the fact if I only load the first 1000, it returns the formatted field correctly.
Anyone has any idea of what might be happening?

Labels (2)
1 Solution

Accepted Solutions
KingVegi
Contributor II
Contributor II
Author

Hello Brun, I then realised what was happening, so basically for some reason the field that I wanted to format already came formatted as a Date, so when I tried to force the DATE# command on it, it basically messed it all up.
But thanks for your availability!

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, Can you provide more details about what you are attempting to accomplish?

KingVegi
Contributor II
Contributor II
Author

Hello Brun, I then realised what was happening, so basically for some reason the field that I wanted to format already came formatted as a Date, so when I tried to force the DATE# command on it, it basically messed it all up.
But thanks for your availability!