Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

SET expression how to add filter year > 2009 ?

Hi All

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

Above expression from sunny , will plot the year from 2000 till YTD , may i know how to add filter to above expression , so that it will plot from year more then 2009 ?

Meaning i only want to see the chart 1 , X axis display from 2009 till 2015.

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: SET expression how to add filter year > 2009 ?

May be this:

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


Capture.PNG

3 Replies
Highlighted
paulyeo11
Valued Contributor II

Re: SET expression how to add filter year > 2009 ?

My QV Doc

MVP
MVP

Re: SET expression how to add filter year > 2009 ?

May be this:

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


Capture.PNG

paulyeo11
Valued Contributor II

Re: SET expression how to add filter year > 2009 ?

Hi sunny

Many thank

Paul