Using a variable in set analysis (for compare)

Anonymous — Mon, 19 Mar 2012 20:10:21 GMT

Hi,

The following expression works perfectly:

=count({<CustomerID={'4'}>}distinct Orders)

However if I insert a variable to replace the 4 as follows I get zero

=count({<CustomerID={'(v_Selected_CounterPart_ID)'}>}distinct Orders)

I have tested the value in the variable and it is 4 so this should work.

The expression editor says the syntax is correct.

The variable is declared as

=GetCurrentField(CounterPart)

Very strange....

Thanks

Mon, 19 Mar 2012 20:14:15 GMT

Try this:

=count({<CustomerID={"$(v_Selected_CounterPart_ID)"}>}distinct Orders)

topic Using a variable in set analysis (for compare) in QlikView