3 Replies Latest reply: Nov 7, 2011 4:57 AM by ravietchno RSS

    connecting to multiple excel spreadsheets ?

      i have a excel spreadsheet that is sent to a ftp every month end, is there a way i can point Qlikview to this folder to do trends and forecasting on the data received over the last year....

      the files have the same cloumns and same amount of rows, just the values change month to month

      eg

       

      Qlikview

      looks at folde2011 which contains file 201110,201109,2011008,etc

      a second question of mine is...

       

      can i link a qlikview file to a database and when opening the file selecting the time frame i would like the qlikview to return

       

      eg.

       

      select * from tblA where date is between AA-BB in the script

       

      upon opening the file ...prompted what is my start date and end date...then returning values accordingly

       

       

      i hope this makes sense

       

      thanks in advance

      Regards

        • connecting to multiple excel spreadsheets ?

          Hi markde101,

                                     Do you want to restrict the records selection in front end or Back end with sql queiry.

          Regards,

          Ravi.

            • connecting to multiple excel spreadsheets ?

              Hi Ravi

               

              Thank you so much for your reply, i am hoping to restrict records by the user entering parameters on the front to be used on the sql back end

               

              similar to sql/crystal reporting parameters.

               

              Is this possible

               

               

              ie select * from tblA where date > '?start_date' and < '?end_date?'

               

              upon opening the qlikview project the user will be prompted to enter a start and end date, which will complete the sql  on the backend, thuis generating results

                • connecting to multiple excel spreadsheets ?

                  Hi markde101,

                                             This can be possible, Please find the attached application where i connected to MS Access database and restricted with input parameters through front end and passing those values in back end.

                   

                  Employee:

                  LOAD EmployeeBusinessEntityID,

                      FirstName,

                      LastName where EmployeeBusinessEntityID >= $(vfrom) and EmployeeBusinessEntityID <= $(vto);

                  SQL SELECT EmployeeBusinessEntityID,

                      FirstName,

                      LastName

                  FROM Employee;

                   

                  I am not able to attach the application but this script may help you and create two input boxes and passed the values into where clause.

                   

                  Let me know if this is not the case.

                   

                   

                  Regards,

                  Ravi.