Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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