topic Re: Set Analysis Error in QlikView

Set Analysis Error

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to calculate and display last date which belongs to previous year in a Textbox by using below formula but getting error, I have implemented variable "Vpreviousyear" at script level for calculating previous year which I am using in formula

Formula : =max({<Year={$(=Vpreviousyear)}>}Claim_Creation_Date)

Error: Error in set modifier adhoc element list ',' or ')' expected

Vpreviousyear: Year(max(addmonths(Claim_Creation_Date,-12)));

Re: Set Analysis Error

effinty2112 — Fri, 24 Jun 2016 09:52:48 GMT

Helo,

Try:

=max({<Year={$(=-1+Max(Year))}>}Claim_Creation_Date)

Regards

Andrew

Re: Set Analysis Error

swuehl — Fri, 24 Jun 2016 09:57:46 GMT

Try

Formula : =max({<Year={$(=$(Vpreviousyear))}>}Claim_Creation_Date)

Re: Set Analysis Error

Anonymous — Fri, 24 Jun 2016 10:07:49 GMT

try this?

=max({<Year={$(Vpreviousyear)}>} Claim_Creation_Date)

Re: Set Analysis Error

susovan — Fri, 24 Jun 2016 10:10:05 GMT

Try this,

=max({<Year={"$(Vpreviousyear)"}>}Claim_Creation_Date)