topic Update Multiple Field values based on selections in QlikView

Update Multiple Field values based on selections

paulm — Sun, 04 Mar 2012 15:48:12 GMT

Hi,

I am currently creating adocument to allow the user to forecast future revenuebased on price changes. Currently a user can edit anindividual price through an editable table, but Iwould like to be able to edit a group of pricesin one go based on the current selections.

Would anyone have asuggestion for how you could write a macro to do this, or if you have a different suggestion? Any help would be much appreciated.

Thanks,

Paul

Update Multiple Field values based on selections

Anonymous — Sun, 04 Mar 2012 19:27:34 GMT

Hi Paul,

Think of using variables and/or set analysis. You question is too open to give a more specific answer. It doesn't look like you need a macro for this, although it may be used as a paert of the solution.

Regards,
Michael

Re: Update Multiple Field values based on selections

paulm — Sun, 04 Mar 2012 23:13:06 GMT

Hi Michael,

Thank you for taking the time to reply. I have attached an example doc I have been playing around with.

Basically we have a few hundred customers which we group. I would like to have an input box where I could enter a Rate then it updates every customer who is currently selected.

e.g. if I have selected customer A in my example I would like on the click of the button to only update records 1 2 and 3.

Hopefully I am missing something simple to do this.

Many thanks,

Paul

Re: Update Multiple Field values based on selections

Anonymous — Mon, 05 Mar 2012 06:04:10 GMT

Hi paulm

Hope the attached macro qv file will be helpful for you...

Regards

Ashok

Update Multiple Field values based on selections

qliksus — Mon, 05 Mar 2012 07:47:09 GMT

Hi try this macro

sub updateRate

set Cnt = ActiveDocument.Fields("ID").getpossiblevalues

for i = 1 to Cnt.count

set obj = ActiveDocument.GetSheetObject("CH01")
obj.SetInputFieldCell i,1, Activedocument.variables("vRate").getcontent.string

end sub

let me know if there are any issues

Re: Update Multiple Field values based on selections

paulm — Mon, 05 Mar 2012 14:52:15 GMT

Hi Guys,

This looks to be exactly what I am after! Great work! Thanks!

Paul