Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Using QV to input data into excel spreadsheets

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

1 Reply
shumailh
Contributor III

Using QV to input data into excel spreadsheets

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