Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Dynamic update action in QV 11

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?

53 Replies
Not applicable
Author

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

sebastiandperei
Specialist
Specialist

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

pablolabbe
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

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

Hi Matthias Dix,

How would I loop to only update changed data?

Bob Zagars

bob_zagars
Contributor II
Contributor II

Hi Matthias Dix,

How would I loop to only update changed data?

Bob Zagars

Not applicable
Author

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

bob_zagars
Contributor II
Contributor II

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