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: 
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