16 Replies Latest reply: Oct 18, 2012 9:50 AM by haagenfels RSS

    Group by clause in Load statement



      I am trying to use a group by clause in QLikview 10.  I have this so far, but keep getting a load script failure.




           Count(SubsectionAddressed)as Grouptest


      FROM http://sharepointreporting.com/sites/compliance/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}&View={XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXX} (XmlSimple, Table is )


      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.