Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.