Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
Showing results for 
Search instead for 
Did you mean: 

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:


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:


Here is the call for value:


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


Thank you for any help


Labels (2)
0 Replies