Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

0 Replies