Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ecolomer
Honored Contributor II

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

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?

Tags (3)
6 Replies
MVP
MVP

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

some ideas in the attachments, hopeto understand

ecolomer
Honored Contributor II

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

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
Honored Contributor II

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

New file QV

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

ecolomer
Honored Contributor II

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

Any idea for resolve this???

TX in advance

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

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.


talk is cheap, supply exceeds demand
ecolomer
Honored Contributor II

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

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.

Community Browser