topic Re: Possible to change field - formula with button click in QlikView

Possible to change field - formula with button click

Sat, 03 Sep 2011 18:48:00 GMT

Hi,

i'm working with QlikView 10.

I wonder if it's possible to change the field-formula of a listbox in a macro?

The initial field-formula is =if(aggr(sum(BETRAG_VP) <> 0 , [KONTO_LANG]),[KONTO_LANG])

after button click, the formula should be =if(aggr(sum(BETRAG_LP) <> 0 , [KONTO_LANG]),[KONTO_LANG]) (difference is: BETRAG_VP <> BETRAG_LP).

Unfortunately, i don't know, how to do this. Can anybody help me?

Thanks,

David

Possible to change field - formula with button click

Jason_Michaelides — Sat, 03 Sep 2011 22:51:57 GMT

Hi David,

I don't think you need a macro here. Put your formula in a variable e.g. vExpression and use the External > Set Variable action within a standard button to change it.

Hope this helps,

Jason

Re: Possible to change field - formula with button click

llauses243 — Sun, 04 Sep 2011 01:28:56 GMT

Hi,

This is my offer,pls to see image adjust

Good luck, Luis

Possible to change field - formula with button click

Jason_Michaelides — Sun, 04 Sep 2011 06:42:29 GMT

Remember that in v10 actions are multi-threaded whereas macros use only a single CPU core. Always best to avoid macros if there's a simple alternative.

Possible to change field - formula with button click

Sun, 04 Sep 2011 17:21:51 GMT

Thanks a lot.

So, i combined you two solutions.

the expression is: =if(aggr(sum($(vFieldCost)) <> 0 , [KONTO_LANG]),[KONTO_LANG])

with button click i change the value of vFieldCost.

So, one question: is it possible to use a condition expression for the value attribute under "External > Set Variable action"?

like: =if($(vFieldCost) = 'BETRAG_VP', 'BETRAG_LP', 'BETRAG_VP')

if i used the named condition, qlikview set the variable to "-".

Possible to change field - formula with button click

Jason_Michaelides — Sun, 04 Sep 2011 17:24:42 GMT

Should be fine to do that. Can you post your qvw and I'll take a look?

Jason

Re: Possible to change field - formula with button click

Sun, 04 Sep 2011 17:41:58 GMT

jo, i created a demo project with the same behavior

Re: Possible to change field - formula with button click

llauses243 — Sun, 04 Sep 2011 18:11:54 GMT

Hi,

This is my offer,pls to see image adjust

Good luck, Luis

Re: Possible to change field - formula with button click

Sun, 04 Sep 2011 18:29:10 GMT

hey,

that's working very fine.

Thanks a lot!

David

Possible to change field - formula with button click

Jason_Michaelides — Sun, 04 Sep 2011 21:45:57 GMT

Yep - Luis's solution is what I would also advise. Always try to use the native functionality if possible!