Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use a group by clause in QLikview 10. I have this so far, but keep getting a load script failure.
LOAD
SubsectionID,
Count(SubsectionAddressed)as Grouptest
WHERE SubsectionAddressed = ' '
GROUP BY SubsectionID
Could this be occuring because of where i am loading this from? Sharepointpage? When I show the field information for SubsectionAddressed it bring up blanks or YES which is why I am looking for blanks ' '.
Thank you in advance.
What is the error message?
I see you are now using ows_SubsectionID instead of SubsectionID. Are you sure the ows_* fields exist in the xml table?
And make sure you end the statement with a semicolon ;
Try like:
LOAD
SubsectionID,
sum(if(SubsectionAddressed='',1,0))as Grouptest
FROM http://sharepointreporting.com/sites/compliance/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0... (XmlSimple, Table is Group by clause in Load statement)
WHERE SubsectionAddressed = ' '
GROUP BY SubsectionID
I tried it with the ; and still recieved a load failure. The original field name is SubsectionID but when i pull it into qlikview through a web file it adds the ows_ in front of all fields.
I tried your suggestion as well. Should I not be including (XmlSimple, Table is [xml/data/row]) a the end of the file location? I also recieved a load script failure error message.
Does anyone have more insite on this?
I tried with this statement below but keep getting a loadle listed below in my qlikview to bring in other data. Does that matter?
LOAD
ows_SubsectionID,
Count(ows_SubsectionAddressed)as Grouptest
RESIDENT [http://sharepointreporting.com/sites/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}&View={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}] (XmlSimple, Table is [xml/data/row])
WHERE ows_SubsectionAddressed = ''
GROUP BY ows_SubsectionID,
ows_SubsectionAddressed
Thank you
Have you done this (as noted above)
And make sure you end the statement with a semicolon ;
I think I figured it out. I switched to using a Resident and then added the ; as well. I need to play with it a little more to get the answers i am looking for but it no longer brings a load script error.
Load
ows_SubsectionID,
sum(if(ows_SubsectionAddressed='',1,0)) as Grouptest
RESIDENT SubsectionWorkstream
//Count(ows_SubsectionAddressed)
//sum(if(ows_SubsectionAddressed='Yes',1,0)) as Grouptest
WHERE ows_SubsectionAddressed = ''
GROUP BY ows_SubsectionID;
Thank you.