topic Change values in a field in a pivot table. in QlikView

Change values in a field in a pivot table.

nancymarmat — Wed, 24 Oct 2018 17:21:58 GMT

I would like to be able to change the values in a field after re-loading data. What is the best method to accomplish this task? My first thought was to create an input field and update the field using a numeric value (InputSum). I used ROW_NUMBER to create a unique field in each record, however the input field is not reset when new data is loaded. How do I reset the input field for every record each time I reload data? I did see postings for a macro to reset the input field values, but was unsure how to create the macro, save it and how to execute it when I reload data. Any help would be greatly appreciated.

Re: Change values in a field in a pivot table.

chrismarlow — Wed, 24 Oct 2018 19:16:41 GMT

Nancy,

There is a suggestion here Reset Inputfield values on using a bookmark to reset the values, which will probably be less out there than the macro approach.

You could set your bookmark (with no input field values entered) to be set after reload using document properties - triggers.

Regards,

Chris.

Re: Change values in a field in a pivot table.

nancymarmat — Fri, 26 Oct 2018 18:15:40 GMT

Thank you very much for your help.