How to use Dynamic update action in QV 11

[#1]

Hi,

Can any one tell me how to use the Dynamic update action in QV 11 .. Do We need to write macro to use this?

[#2]

I would like to know, what you experienced with your dynamic update solutions. any problems or further good ideas?

[sebastiandperei]

I didn't used it, but since now, is a new tool!!

[pablolabbe]

Hi Mathias,

  The example is great. Now I understood how to use the new action "Dynamic Update" in QV11.

   I was thinking if could be possible to use "dynamic update"  commands to update a field with values from a calculated expressions like : sum(aggr( if (sum (Sales)> 10000, 1, if (sum (Sales)> 5000, 2, 3)),CustomerName)).

  The expression calculates the total sales for each customer and groups customers in 3 types.  The requirement don´t allow me to calculate this in script, have to create it dynamically based on several filters like location and sales month/Year.

  The problem is how to setup this field to a list of  thousands of customer.

Best Regards,

Pablo Labbe

[#5]

What you describe so far should be possible in script. Just build some temp tables at the end of your script, where you do all the grouping (read help on "group by"-statement in load). it could also be possible to use partial reload for your use case.

dynamic update does not let you use WHERE statements with < > only =

maybe you can share some more details, so that we can help you out on that.

regards

Matthias

[#6]

Matthias -

In your example you have "Dynamic Update" - 'Insert' statement with hardcoded values. I am trying to do an insert with values based on a field selection. I tried writing a statement something like

Insert into Test(Mgr)

select getFieldSelection(Manager2)

Not working of course. Any suggestions?

[#7]

Hi Philippe,

Did you find a solution to this? I have only tested on Windows 7 so far and I did observe that only users part of QlikView Administrators group are able to do Dynamic Updates.

Greatly appreciate you sharing any further insight.

Thanks!

[bob_zagars]

Hi Matthias Dix,

How would I loop to only update changed data?

Bob Zagars

[bob_zagars]

Hi Matthias Dix,

How would I loop to only update changed data?

Bob Zagars

[#10]

Could you explain in more detail what you want to achieve?

[bob_zagars]

Matthias Dix,

Does this Dynamic Update only pertain to in memory data?  I am building something like the budget process where I need to update budget amounts to the source via INPUTFIELD values.  The loop would be all changes.

IF ValueChanged THEN

     UPDATE BudgetTable SET CurrentBudget = FieldValue(INPUTFIELD) WHERE BudgetTable.RowID = RowID;

END IF

Thanks,

Bob