topic Re: Formula setting variable in QlikView

Formula setting variable

clovati — Tue, 17 Nov 2015 12:47:52 GMT

Dear all....

I have a variable:

eGMS = Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

In some cases, there is a button that put eGMS = 'G'.

With a trigger when I leave the sheet (where there is the button) I am trying to give the variable the formula variable but I'm not able :-(.

I tried also with a 2nd variable i.e.:

* eGMS_Formula = Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

* trigger : eGMS = $(eGMS_Formula)

* trigger : eGMS = '$(eGMS_Formula)'

but I've not the possoibility to make variable as expression/ formula.

THANKS a lot!

CriL

Re: Formula setting variable

Mark_Little — Tue, 17 Nov 2015 13:32:11 GMT

Hi,

What is it exactly you are wanting to happen here?

On leaving the sheet what are you try to get into a variable?

Is this the actual string value 'Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')'?

Mark

Re: Formula setting variable

clovati — Tue, 17 Nov 2015 13:47:14 GMT

Hi Mark! Thanks first af all.

Yes, I want eGMS will still be 'Pick...' as when I open QWV ex-novo.

Re: Formula setting variable

Peter_Cammaert — Tue, 17 Nov 2015 16:56:49 GMT

In the action expression field, enter this:

='= Pick(Match(GetCurrentField([MM-WK-GG]), ' & chr(39) & 'DataVend' & chr(39) & ', ' & chr(39) & 'MMM' & chr(39) & ', ' & chr(39) & 'WK' & chr(39) & '), ' & chr(39) & 'G' & chr(39) & ', ' & chr(39) & 'M' & chr(39) & ', ' & chr(39) & 'S' & chr(39) & ')'

I may have accidentally omitted a single quote. Check the number of quotes if it doesn't result in eGMS containing the correct formula.

Re: Formula setting variable

rwunderlich — Tue, 17 Nov 2015 18:50:53 GMT

Enter the trigger value expression without $(). You don't want it evaluated, you want the literal string.

trigger : eGMS = eGMS_Formula

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Formula setting variable

Mark_Little — Tue, 17 Nov 2015 19:18:42 GMT

Hi,

Just like Rob has mentioned. Just enter the string like

Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

Mark

Re: Formula setting variable

clovati — Wed, 18 Nov 2015 10:50:09 GMT

That's ok! Thanks a lot!

Re: Formula setting variable

rwunderlich — Wed, 18 Nov 2015 14:52:38 GMT

Peter, I don't understand the need for escaping all the quotes. Since the expression string is not dynamic, can't it just be entered in the Action Value directly as:

Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

-Rob

Re: Formula setting variable

clovati — Wed, 18 Nov 2015 14:54:48 GMT

I want to mark as RIGHT ANSWER.. but where?

Da: Rob Wunderlich

Inviato: mercoledì 18 novembre 2015 15:53

A: Lovati Cristina

Oggetto: Qlik Community: New reply - Formula setting variable

Re: Formula setting variable

oknotsen — Wed, 18 Nov 2015 15:25:29 GMT

How about clicking "Correct Answer" near the post that is the correct answer?

Re: Formula setting variable

clovati — Wed, 18 Nov 2015 15:48:13 GMT

Da: Onno van Knotsenburg

Inviato: mercoledì 18 novembre 2015 16:26

A: Lovati Cristina

Oggetto: Re: - Formula setting variable

Re: Formula setting variable

oknotsen — Wed, 18 Nov 2015 16:03:26 GMT

Hmmm... Apparently your interface looks different then mine.

Anyway,

I marked it for you.

Re: Formula setting variable

Peter_Cammaert — Thu, 19 Nov 2015 07:30:45 GMT

Rob,

I was assuming that she wanted to assign the formula string to the variable, instead of the formula result. Wrong assumption apparently.

BTW your post below does the same but in a much more efficient way.I learned a thing, again. Thanks.

[Edit] On rereading your post, I finally saw that you omitted the equal sign. Pfffft, it's getting worse... I should become a member of your "we test before we post"-association