Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

paulyeo11
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

Community Browser