Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
notlarrybell
Contributor
Contributor

String with State not working as a set expression

Thank you in advance for your help. I am very stuck.

I have a variable set up as an expression which accepts a numeric value as a parameter and returns a string with a viable set expression:

The call is:

$(vAtest([RowDimension]))

where vAtest is defined as:

'=count({State' & $1 &'}OwnerID)'

I have 6 states defined as State1, State2, ... State6

Everything works as expected if I just view the string in a row as the return of the call, but when I try to call the function to be evaluated as an expression it doesn't pick up RowDimension, returning count({State}OwnerID) which is 0 (there is no state called 'State').

qlik question.JPG

 

Here is the call for Returned String:

$(vAtest([RowDimension]))

Here is the call for value:

$(=$(vAtest([RowDimension])))

I can hardcode the parameter and it works correctly, e.g.:

$(=$(vAtest(1)))

Thank you for any help

 

Labels (2)
0 Replies