1 Reply Latest reply: Nov 15, 2009 6:07 PM by Shumail Hussain RSS

    Using QV to input data into excel spreadsheets

    rygreene3

      Hello

      Perhaps I can ask my question best by explaining what I'm attempting to do.

      Lets say I set a filter in my QV application that gives me a data set of 10 records. I would like to export those 5 records to an excel spreadsheet. In addition to those records, I would like to have the ability to manually add a value that would be exported to the excel spreadsheet and appear in it's own column for each record. It would appear something like the following, with the value of $1.00 added at the time the five records are exported to the spreadsheet:

      Product ID Price
      ABCD $1.00
      EFGH $1.00
      IJKL $1.00
      MNOP $1.00
      QRST $1.00

      Thanks for any insight and assistance

      Ryland

        • Using QV to input data into excel spreadsheets
          Shumail Hussain

          Hi Ryland,

          In qlikview you can input data using input box by using variable,

          you can create new table using inline data wizard using EDIT SCRIPT.

           


          LOAD * INLINE [
          ProductID, Price
          ABCD, 1
          EFGH, 1
          IJKL, 1
          MNOP, 1
          QRST, 1
          ];


          as far as adding values while exporting data to excel is concern so i think we dont have any event for excel export, we need to work on API for this.

          Regards,
          Shumail