Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incorrect Data Format while reading calculated fields from SharePoint list

The data format is incorrect when I read calculated fields from a SharePoint list into QlikView. For example, I am reading the Material# field into QlikView from SharePoint. The value in SharePoint is "101294675". The  value shown in QlikView is  "float;#101294675.000000".  Is there a script change I can make to ensure the value is diplayed as 101294675

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This should work, I think:
floor(subfield("Material#", '#',2)) as "Material#"

View solution in original post

2 Replies
Anonymous
Not applicable
Author

This should work, I think:
floor(subfield("Material#", '#',2)) as "Material#"

Not applicable
Author

Thank you Michael.