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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String Variable In Expression

Hi there,

I have the following expression, and would like to replace the word 'Centre' right at the end with a variable (vGroupBy), which says 'centre')

I can't seem to get this to work though. I assume I am not concatenating correctly or doing something wrong with my syntax?

(Count(if(AssessmentDate >= $(vAssessmentStartDate) AND AssessmentDate <= $(vAssessmentEndDate), Passed)),Centre)

Thanks in advance.

1 Reply
Greg_Williams
Former Employee
Former Employee

$(vCentre) (if using SET)

or

vCentre (if using a LET)