How to load an inputfield with the result that a variable

MarcoARaymundo — Fri, 29 Jan 2016 12:31:25 GMT

Hi,

In my load script I created a inputfield type field.

Ex inputfield inPrecoImpII.;

In the application there is a variable that returns a formula.

Ex.

If (Ref = 'AVGCliente'

If (Rule = '>',

If (KeepChar (vValorInf, '%') = '%',

'Avg ({<= $ Promo :: Promo>} PREÇOCV) + (Avg ({<= $ Promo :: Promo>} PREÇOCV) * vValorRef)' ,

'Avg ({<= $ Promo :: Promo>} PREÇOCV) + vValorRef'

If (Rule = '<',

If (KeepChar (vValorInf, '%') = '%',

'Avg ({<= $ Promo :: Promo>} PREÇOCV) - (Avg ({<= $ Promocionado :: Promo>} PREÇOCV) * vValorRef)' ,

'Avg ({<= $ Promo :: Promo>} PREÇOCV) - vValorRef'

'Avg ({<= $ Promo :: Promo>} PREÇOCV)'

)

I need a formula variable is "inserted" in inputfield field as a result.

Without using inputfield everything is working, however, the client wants the ability to change the results.

I want to avoid using macros.

Any idea?

tks Marco

Re: How to load an inputfield with the result that a variable

Gysbert_Wassenaar — Fri, 29 Jan 2016 16:38:18 GMT

You can't use set analysis in the script. That means you can't calculate the value with that expression in the script and load it in the input field. And only a user can change the value of an input field in the UI. But perhaps a macro works. See this document for an example: Use a macro to update InputField. I doubt that will work in the ajax client though. Another option you can explore is using a Dynamic Update action: Dynamic Update - Using Actions.

topic How to load an inputfield with the result that a variable in QlikView

How to load an inputfield with the result that a variable

Re: How to load an inputfield with the result that a variable