Set analysis

[stephenedberkg]

i have two calendar one for uploading month and year and another one is forecast month and year

in my dashboard i made uploading month and year as calendar

but the above screen shot values is wrong

each code have some lock period like 1,2,3.

since code CP6426 has lock period as 2 i want the march sales values

i want achieve this without clicking march.

my expression is =sum({<Years={$(=Max(Years))},MonthIDS = {$(=Max(MonthIDS))}>}Sales)

how to write this logic in set analysis

[tresesco]

Not very clear what you are trying to get. Is March your max month? What is it's MonthID number? Could you explain a bit more?

[HirisH_V7]

Hi,

Can you post your sample app and Required output??

-Hirish

[stephenedberkg]

not like that when we click jan its should display jan + lock period that is 1+ 2 =3 that is  march

[tresesco]

Try like:

Create a variable like:

vLockPeriod =LockField

=sum({<Years={$(=Max(Years))},Month= {$(=Month(Addmonths(Max(DateField),$(vLockPeriod))))}>}Sales)

[#6]

sample app

[stephenedberkg]

i have the master calendar for both upload and forcast

[tresesco]

All questions to be followed would be answered if you could upload your sample qvw.

[stephenedberkg]

i have attach the sample QVW file and excel data.

help me.

[stephenedberkg]

i attach the sample qvw file