topic How to modify the expression So that it still work when current month and year not selected in QlikView

How to modify the expression So that it still work when current month and year not selected

paulyeo11 — Thu, 03 Mar 2016 15:08:21 GMT

Hi All

I have below expression working fine ( Ref to chart 1 ) , when year = 16 and month = 3 :-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales)/1000

May i know how to change the above expression still working , when year and month is not selected. So that i can use the same expression in QS. with out need to activate current month and current year.

Paul

Re: How to modify the expression So that it still work when current month and year not selected

sunny_talwar — Thu, 03 Mar 2016 15:18:32 GMT

Try this expression:

sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales)/1000

Re: How to modify the expression So that it still work when current month and year not selected

paulyeo11 — Thu, 03 Mar 2016 23:07:50 GMT

Hi sunny

Thank you vey much.

Paul