Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify field value with macro

Hello!

I am trying to change the values of fields using macro.

I have commented the algorithm (for loop) and tried very simple test :

fld.SetInputFieldValue 0, "999"

I only want that the first row is set to 999, but event this does not work.

Here is the output when I press the "Test" button in QV...

error modifying field.bmp

Any idea?

Thank you all for the help!

Hubert

1 Solution

Accepted Solutions
IAMDV
Master II
Master II

Hi Hubert,

Have you specified "%WORST_SFFR_ITEM") as InputField in the Load Script? If not please use the InputField keyword in Load Script and also look at this thread.

I hope this helps!

Cheers - DV

View solution in original post

3 Replies
IAMDV
Master II
Master II

Hi Hubert,

Have you specified "%WORST_SFFR_ITEM") as InputField in the Load Script? If not please use the InputField keyword in Load Script and also look at this thread.

I hope this helps!

Cheers - DV

Not applicable
Author

Hello DV

Many thanks for the hint : it solved everything !!

Just had to add

INPUTFIELD %WORST_SFFR_ITEM

before the load statement and let's rock!

Once again : warm thanks!

Hubert


IAMDV
Master II
Master II

Hi Hubert,

I am glad you got it working. You are welcome

Cheers - DV