Does set analysis work when calling a variable with dollar sign expansion?

Fri, 29 Jan 2010 09:01:46 GMT

The following is my variable definition:

PrintX
if($1>0.9,'X',$1)

When using expression A PrintX produces the correct result but with expression B it does not work.

ie A gives a list of numbers except for numbers larger than 0.9 where it writes an X.

Expression B gives null results.

Expression C gives correct decimal numbers.

A = $(PrintX(0.01* Count( distinct SalesID )))

B =$(PrintX(Count( {$ < Status={"B","G","V"} >}
distinct SalesID) /
 Count(distinct SalesID)))

C =Count( {$ < Status={"B","G","V"} >} distinct SalesID)
/
 Count(distinct SalesID)

Maybe there is another way to write a character for ranges of numbers rather than using a $ sign expansion or am I doing something wrong in expression B?

topic Does set analysis work when calling a variable with dollar sign expansion? in QlikView

Does set analysis work when calling a variable with dollar sign expansion?