Expressions nested in other expressions

Wed, 21 Sep 2016 14:46:23 GMT

Hello to everyone!

I hope somebody could help me with the problem I'm facing:

In a external .qvs I'm setting the following variables:

SET exp1 = Avg({1<Field1={'Value1'},Field2={'$1'}>}Field3);

SET exp2 = 'Value2';

SET exp3 = ((Sum({<Field3={$1}>}Field4 * Field5))/Sum({<Field3={$1}>}Field6));

SET exp4 = If(QV_Show_Time='Quarterly',

If($(exp1($(exp2)))>=$(exp3('Value3')),

vt_ColorPositive,

If($(exp1($(exp2)))>=($(exp3('Value3')) - 0.05) and $(exp1($(exp2)))<$(exp3('Value3')),

' ', vt_ColorNegative)));

Where QV_Show_Time is also a Field, and vt_ColorPositive and vt_ColorNegative are colors defined using the RGB() function.

I use the expression 'exp4' to compare two values and change the font color from a straight table. When I copy exp4 to 'Text Color' of the object it works fine. But if that expression is defined outside in a .qvs it doesn't work. I think that there is one ore more expressions that may be are called wrong (maybe using $(=exp)), but I tried almost all and I didn't found the mistake.

I'll appreciate all the help.

Thanks!

Re: Expressions nested in other expressions

Thu, 22 Sep 2016 07:20:46 GMT

I think I got it! All I have done is to use 'exp4' as a function, replacing the 'exp1' parameter ($(exp2)) with $1 and call the function as following:

$(exp4($(exp2)))

This worked for me. My question is: all expressions using other expressions with parameters, must be paremeterized also with those parameters?

Thanks!

topic Expressions nested in other expressions in QlikView

Expressions nested in other expressions

Re: Expressions nested in other expressions