Asign to many lines a value from a variable and generate QVD

[ecolomer]

I have  an Orders table with some fields ... ID, Customer, Date, Amount, and other data ...

From the list of orders, you can select a few (depending on user criteria) and those selected and only those Orders, I want to assign a value (Lot) that the user enters into an input table in a variable (vLote) .

Then I want to generate a file consisting qvd Order ID and Lot number assigned

Any help?

[maxgro]

some ideas in the attachments, hopeto understand

[ecolomer]

Hi, Tank's but is not exactly, because I need assign Lot only selected "OrderId"

I have OrderId with Lot assigned (for the last session) and OrderId without Lot

When user have the OrderId selected then push button to assign Lot for these OrderId selected and only for these.

I attached the test QV

[ecolomer]

New file QV

I this moment I can put individualy Lot to each OrderId in the table at rigth

[ecolomer]

Any idea for resolve this???

TX in advance

[Gysbert_Wassenaar]

Qlikview is not a data entry application. But perhaps you can use this: Users can map/group dimensions at run-time! Or maybe the dynamic update feature: grouping dimension values. You'll be hard pressed to generate a qvd though. Exporting to for example Excel is something the users could do themselves, but qvd's can only be generated by the script during a reload.

[ecolomer]

OK, thanks for the reply.

Yes, I know that QV is not a data entry tool, but I need this for a much more complex process.

If you think of any other solution, I'd appreciate it.

Thank you very much.