Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

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
sunny_talwar
Not applicable

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

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

My QV Doc

sunny_talwar
Not applicable

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
Not applicable

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

Hi sunny

Many thank

Paul