Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

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