topic Re: Set Analysis - '}' expected in QlikView

Set Analysis - '}' expected

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Set Analysis - '}' expected

Tue, 19 Jul 2016 12:26:00 GMT

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

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

Re: Set Analysis - '}' expected

Chanty4u — Tue, 19 Jul 2016 12:27:37 GMT

here

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

Re: Set Analysis - '}' expected

Anil_Babu_Samineni — Tue, 19 Jul 2016 12:27:58 GMT

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

Re: Set Analysis - '}' expected

arulsettu — Tue, 19 Jul 2016 12:28:05 GMT

try this

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

Re: Set Analysis - '}' expected

boorgura — Tue, 19 Jul 2016 12:31:26 GMT

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

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

Re: Set Analysis - '}' expected

saimahasan — Tue, 19 Jul 2016 12:35:00 GMT

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.

Re: Set Analysis - '}' expected

Clever_Anjos — Tue, 19 Jul 2016 12:38:47 GMT

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

Re: Set Analysis - '}' expected

Tue, 19 Jul 2016 13:03:58 GMT

Rodrigo,

Thank you for that, that was what was missing!

Re: Set Analysis - '}' expected

Tue, 19 Jul 2016 13:05:33 GMT

Thanks all for you help, really appreciate!

Re: Set Analysis - '}' expected

effinty2112 — Tue, 19 Jul 2016 13:18:03 GMT

Hi,

A useful tip is to type your brackets in pairs then go back a space and fill in the content, so in the is case type {} then go back inside the brackets and enter your text.

Cheers

Andrew

Re: Set Analysis - '}' expected

vishsaggi — Tue, 19 Jul 2016 13:25:08 GMT

I always do this when every i am writing a set analysis:

Typing {< >}

= Sum( {< >} YearMonth)

And then start from there.

Thanks,