topic Re: A variable with IF and a parameter doesn't work in App Development

A variable with IF and a parameter doesn't work

dana — Sun, 20 Nov 2022 15:55:24 GMT

Hi People,

I created a variable to calculate a background color with the following expression:

=If($(vRepDelivYaad)=$1,vColorDarkGrey,vColorLightGrey)

But I get the message: Error in expression.

Adding literals removes the error message, but always return the false (vColorLightGrey)

=If($(vRepDelivYaad)='$1',vColorDarkGrey,vColorLightGrey) .

Calling the variable either $(vTest(2)) or $(vTest('2')) doesn't resolve the issue.

Any Idea?

Thanks in Advance!

Re: A variable with IF and a parameter doesn't work

Michiel_QV_Fan — Tue, 22 Nov 2022 14:22:21 GMT

Not sure where the $1 is referring to.

If you do this: If($(vRepDelivYaad)='2',LightGray(),LightGreen()) and you enter the value 2 in the variable in an inputbox it works as expected.

vRepDelivYaad is comparing to the value $1 that should be entered in the variable like this:

In your script:

LOAD * Inline [

KPIID, Formula

abc , Sum(Volume)

];

SET UDF_Formula = Only({1<_KPIID = {$1}>}_KPI_Formula);

In your expression: = $(UDF_Formula(abc)) will resolve to the expression Sum(Volume)

$1 is replace by abc in this exaple.

Re: A variable with IF and a parameter doesn't work

dana — Tue, 22 Nov 2022 15:17:56 GMT

Hi,

Thanks for your suggestion..

The variable vRepDelivYaad is updated by the button, which its background color is defined by the formula:

=If($(vRepDelivYaad)=$1,vColorDarkGrey,vColorLightGrey)

Another words, vRepDelivYaad can't be replaced by script.

Re: A variable with IF and a parameter doesn't work

Michiel_QV_Fan — Tue, 22 Nov 2022 15:25:50 GMT

What kind of value will replace $1? your variable is comparing like 1=1

$(vRepDelivYaad) = X

Re: A variable with IF and a parameter doesn't work

dana — Tue, 22 Nov 2022 15:51:05 GMT

Exactly!

the idea is to use one expression for all buttons.

Re: A variable with IF and a parameter doesn't work

Michiel_QV_Fan — Wed, 23 Nov 2022 07:09:02 GMT

Sorry, I still don't get what your goal is.

Re: A variable with IF and a parameter doesn't work

dana — Wed, 23 Nov 2022 08:02:50 GMT

Hi,

I'll be more specific:

There are a few buttons which are used to toggle between display options: (action is update variable vRepDelivYaad)

The current choice is displayed with the black background.

So instead of writing a similar background expression for each button:

=If($(vRepDelivYaad)=1,vColorDarkGrey,vColorLightGrey)

=If($(vRepDelivYaad)=2,vColorDarkGrey,vColorLightGrey)

I thought of using another variable with the same expression and a parameter , e.g., vButtonBackground:

=If($(vRepDelivYaad)=$1,vColorDarkGrey,vColorLightGrey)

called from each button:

$(vButtonBackground(1))

$(vButtonBackground(2))

Does it make sense?

Thanks for willing to help me!