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: 
Anonymous
Not applicable

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],', '))')

2 Replies
sunny_talwar

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],', '))

Anonymous
Not applicable
Author

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.