Discussion board where members can learn more about Qlik Sense Data Connectivity.
if anyone has any ideas about how to resolve the following please:
I am pulling data from a Sharepoint site
there are a few fields which are set up as Checkboxes and these fields can be multi select e.g. the country field
If i pull this field into Qliksense in a normal load, the country field is displayed as "SYSTEM.String"
FIELDNAME AS COUNTRY
FROM SHAREPOINT SITE;
I am trying to resolve this by using SubField() function in the LOAD Script
LOAD"ID",Subfield(Country,','1) as CountrySplit
however it looks like the field is being brought through with all values as SYSTEM.STRING so this subfield doesnt work, and if i do a SubStringCount('[') it will return 1 as it picks up the bracket
any ideas how i can get the country to display or be brough back as a country list e.g. one of the values is italy,UK,USA?
thanks very much