How to dynamically change certain value only in a list box

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

I have load a inline table as below

Then in the list box display the filed as below

What I want is that have another button where use can toggle between original and adjustment so that when user select original, the list box will be unchanged, but if the user select adjustment button, some value of the list box will be dynamically changed.

Re: How to dynamically change certain value only in a list box

Sergey_Shuklin — Tue, 19 Dec 2017 05:04:06 GMT

Hello, Ronald!

If your inline loaded field called fld1 then you can try this:

Go to the ListBox general tab and choose expression instead of field. And use Subfield() and Replace() functions to get some changes in output field values.

For instance:

If(Subfield(fld1,'|',3)='Nov', Null(),

Replace(fld1, Subfield(fld1,'|',2), 'ActualAdjustment')

)

And of course this condition should have effect only if the User have pressed certain button.

topic How to dynamically change certain value only in a list box in QlikView

How to dynamically change certain value only in a list box

Re: How to dynamically change certain value only in a list box