Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
Hi Jagan
Thank you very much. Today i learn a lot of SET analysis.
Paul