Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mark_perreault
New Contributor II

Error: Error in expression: ')' expected

I have noticed something strange in Qlik Sense and am wondering if anyone can help.  Below is the expression I am using for the title of a sheet and am getting an Error: Error in expression: ')' expected.  What is strange however is if I change the dimension in the Concat expression then the expression works fine with that other dimension.  Does anyone have any thoughts?

='Details ' &

If(GetSelectedCount([ClientNameDisplay]) > 0 or GetPossibleCount([ClientNameDisplay]) =1,'- $(=Concat(Distinct [ClientNameDisplay],', '))')

Tags (2)
2 Replies

Re: Error: Error in expression: ')' expected

Not sure I understand why you have your dollar sign expansion Concat within single quotes? And why do you need dollar sign expansion? Am I missing something or do you may be need this.

='Details ' & If(GetSelectedCount([ClientNameDisplay]) > 0 or GetPossibleCount([ClientNameDisplay]) = 1,'- ' & Concat(Distinct [ClientNameDisplay],', '))

mark_perreault
New Contributor II

Re: Error: Error in expression: ')' expected

This works thank you! I had used dollar sign expansion within single quotes for other dynamic titles, I did not realize I didn't need to to.

Community Browser