Find offset to update input field

Fri, 30 Nov 2012 13:53:58 GMT

Hello,

In my application I have Sales table with transactionID, date, manager, item and amount.

And I have a separate table with manager and item and budget amount as input field to allow user create budget in the application directly.

I need to copy sum of sales amount by manager and item for particular date to my budgeting table. For example, we need to create a budget for the next month that is 10% more than our current sales.

Is it possible to make a macro that will loop through our sales data aggregated by manager and item for particular date and to copy values into input field?

The main questions are:

1. how to make a loop

2. how to find an offset for "SetInputFieldValue" function for particular combination of manager and item?

Kind regards,

Alexander

topic Find offset to update input field in QlikView

Find offset to update input field