Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],', '))')
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],', '))
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.