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

[paulyeo11]

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

[sunny_talwar]

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

[jagan · Accepted solution]

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.

[paulyeo11]

Hi Jagan

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

Paul