Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results 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))

11 Replies
Not applicable
Author

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

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

MVP

here

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

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
Master III

try this

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

Specialist

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

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

Partner - Creator III

First of all remove the space from [ YearMonth]

Secondly, remove {1}.

Try expression like:

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

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!

Community Browser