Using Macro To Assign & Store Value To A Bucket Filter

[#1]

Hi Community,

When the "Range" filter is selected and the macro button is clicked, the "QlikView" dialog box appears.

When I input a value into this dialog box, it should reflect in the straight table below.

The value assigned through this input dialog box changes when the selection is released.

For example,  when I select 10<=x<20 and input a value 6, the straight table column should show '6'.

And if I select 0<=x<10 and run the macro to assign a value '7', the straight table column should show '7'.

I want to be able to store the value assigned to a particular range through the input box until the same range is selected from the "Range" filter and macro is run on it again which would allow me override the value i assigned on the same range earlier.

How can I achieve this?

Please find the attached qvw file.

Also, kindly let me know if this solution would work on Access Point?

Thanks,