Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - '}' expected

Hello,

I have created the following expression in a textbox:

=max({<Year= {"$(=max({1} Year))"}>Left([ YearMonth],2))

Result:

Error: '}' expected

I already been looking around and I cant spot where the problem is...

Can you give me a hint please!

Thank you!

1 Solution

Accepted Solutions
Not applicable
Author

=max({<Year= {"$(=max({1} Year))"}>} Left([ YearMonth],2))


=max({<Year= {"$(=max({1} Year))"}> here need } Left([ YearMonth],2))

View solution in original post

11 Replies
Not applicable
Author

=max({<Year= {"$(=max({1} Year))"}>} Left([ YearMonth],2))


=max({<Year= {"$(=max({1} Year))"}> here need } Left([ YearMonth],2))

Chanty4u
MVP
MVP

here

=max({<Year= {"$(=max({1} Year))"}>}Left([ YearMonth],2))

Anil_Babu_Samineni

Can you please explain, What do you want to Achieve.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
arulsettu
Master III
Master III

try this

max({<Year= {"$(=max({1} Year))"}>}Left([ YearMonth],2))

boorgura
Specialist
Specialist

=max({<Year= {"$(=max({1} Year))"}>Left([ YearMonth],2))


Why do you have a space within the []  for YearMonth field ??

saimahasan
Partner - Creator III
Partner - Creator III

First of all remove the space from [ YearMonth]

Secondly, remove {1}.

Try expression like:

=max({<Year= {"$(=max(Year))"}>}Left(YearMonth,2))

Hope it satisfies your requirement.

Clever_Anjos
Employee
Employee

=max({<Year= {"$(=max({1} Year))"}> } Left([ YearMonth],2))

Not applicable
Author

Rodrigo,

Thank you for that, that was what was missing!

Not applicable
Author

Thanks all for you help, really appreciate!