4 Replies Latest reply: Jul 24, 2013 11:02 AM by pankajchopra RSS

    Wrong results in running a Qlikview script

      I am running a Sentiment Analysis API in Qlikview. However I get only two sentiment score 0 and 0.25. One for the top header field and other for the first post. My text field has 4 rows in the table Timeine. Why am I not getting the missing ones ? Below is my script. Before this script, I have my data loaded from the table Timeline

       

       

      LET noRows = NoOfRows('Timeline');

        

      for i=0 to $(noRows)-1

         

        

           let text = peek('text', $(i), 'Timeline');

         

           Sentiment:

           LOAD

              '$(text)' as text,

              status as sentiment_status,

              score as sentiment_score

           FROM

           [http://localhost:5555/QVSource/TextAnalyser/?table=Sentiment&SentimentEngine=Alchemy&format=qvx&Message=$(text)]

           (qvx);

          

      next