7 Replies Latest reply: Aug 18, 2016 4:53 AM by espen skeie RSS

    Qlikview will not read field and create a variable

    espen skeie

      Hi

       

      I have this weird problem. I got an excel sheet that got 3 columns

       

      TickerExchangeTickerAndExchange
      TEL.OLTEL.OL
      YAR.OLYAR.OL
      NHY.OLNHY.OL
      NOFI.OLNOFI.OL

       

      I have created three variables so that I can use these values in creating a URL string:

       

      for i=1 to NoOfRows('TickerList')

       

        LET vNameOfStock = FieldValue('Ticker', $(i));

        LET vStockAndExchange = FieldValue('StockAndExchange', $(i));

        LET vNameOfExchange = FieldValue('Exchange', $(i));

       

        LET vFullPathStock = '..\StockMarketAnalysis\QVD\' & '$(vNameOfStock)' & '.qvd';

        LET vFileExsist = if(FileSize('$(vFullPathStock)')>0,-1,0);

       

        if $(vFileExsist) then

             Call Incremental(vNameOfStock, vNameOfExchange);

        Else

             Call NonIncremental(vNameOfStock, vNameOfExchange);

        End if;

       

      Next i;

       

      Somehow the variable vNameOfExchange will only catch the first rows value, and the rest is NULL. I have tried to remove the dot, I have changed the order of the variables, I have tried to empty the variables using LET vNameOfExchange = NULL();

       

      Anyone who knows why this is happening?

       

      Best regards

      Espen