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: 
paulm
Contributor III
Contributor III

Update Multiple Field values based on selections

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi paulm

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

Regards

Ashok

View solution in original post

5 Replies
Anonymous
Not applicable

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

paulm
Contributor III
Contributor III
Author

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

Anonymous
Not applicable

Hi paulm

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

Regards

Ashok

qliksus
Specialist II
Specialist II

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    

next

end sub

let me know if there are any issues

paulm
Contributor III
Contributor III
Author

Hi Guys,

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

Paul