# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor II

## 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

1 Solution

Accepted Solutions
MVP

## 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.

3 Replies
MVP

## 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

MVP

## 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.

Valued Contributor II

## 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