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

    Group by clause in Load statement

      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

           

      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.