Does SET expression allow user select yr=2016 and mth =12 and still able to display value ?

[paulyeo11]

Hi All

My Table have below expression display YTD sales work fine  :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

And below display YTD LY sales :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/Rate)

My question is when user need to compare whole year 2015 vs 2016 from Jan till june sales , user click on year=2016 and month = 12

the table display null value.

May i know how to make it display YTD sales amount for both column ?

Paul

[paulyeo11]

my qvw

[PrashantSangle]

Hi,

In PY YTD dont set month field.Nullify it.

Try like,

Sum({$<year = {$(=Max(year)-1)}, month = , sales = {'*'}>} month))"}>}sales/Rate)

Regards

[MK_QSL]

Not clear from your explanation. Can you provide output which you are looking for?

[Anonymous]

You try to use ADDMONTHS() & ADDYEARS() to your previous year & Month .

[antoniotiman]

Try to remove

,sales={'*'}

or replace with

,sales=

[PrashantSangle]

Hi,

or you can simply set Month value in set analysis for PY YTD.

try like,

Sum({$<year = {$(=Max(year)-1)}, month = {"<=12"}, sales = {'*'}>} month))"}>}sales/Rate)

Regards

[paulyeo11 · Accepted solution]

Hi Antonio

Thank you very much , this is what i am looking for.

Paul

[paulyeo11]

Hi Max

i try it return null value.

Paul

[paulyeo11]

Hi Manish

I have already got the solution on this post , and i have mark correct answer. , that is :-

Try to remove

,sales={'*'}

or replace with

,sales=

Today i learn 2 thing about

,sales={'*'}

1) This allow user not select any value and it will select june.

2) if {'*'} are remove user can select mth =12 and yr=2016 and it can display value.

Paul