3 Replies Latest reply: Apr 4, 2016 11:02 PM by Yeo Poh sai

# what is the purpose of \$<year = {">=\$(=max(year),4)"} ?

Hi All

what is the purpose of \$<year = {">=\$(=max(year),4)"} ?

sum({\$<year = {">=\$(=max(year),4)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

Paul

• ###### Re: what is the purpose of \$<year = {">=\$(=max(year),4)"} ?

This doesn't seem like right syntax:

Sum({\$<year = {">=\$(=max(year,4)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

where max(year, 4) is the 4th max value of year

• ###### Re: what is the purpose of \$<year = {">=\$(=max(year),4)"} ?

Hi Paul,

it should be

\$<year = {">=\$(=max(year,4))"}

Which gives you the fourth maximum year value.

Check Max() in the Qlikview help file.

Regards,

Jagan.

• ###### Re: what is the purpose of \$<year = {">=\$(=max(year),4)"} ?

Hi Jagan

Thank you very much. Today i learn a lot of SET analysis.

Paul