Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
mov
Esteemed Contributor III

Incorrect Data Format while reading calculated fields from SharePoint list

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

2 Replies
mov
Esteemed Contributor III

Incorrect Data Format while reading calculated fields from SharePoint list

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

Not applicable

Incorrect Data Format while reading calculated fields from SharePoint list

Thank you Michael.

Community Browser