Set Analysis – summing value depending on selected periods

[wonkymeister]

I have a summing up issue!!!

I have a selector box of values 1 – 12 (periods)

Loaded into qilkview I also have days per period i.e. period 1=31 days, period 2=28 days ,period 3=31 days etc…

What I’m trying to achieve is to sum the daysPerPeriod depending on the periods selected (or even better to remove user input and to sum the total days for the total periods currently available for the max year)

I’ve tried hardcoding the year and periods available into a variable to pull back the total days but get crazy numbers.

What I really want to do is to sum(daysPerPeriod) where Year = max(Year) and Period = total periods available for year selected

any help greatly appreciated

daysPerPeriod	Year	Period
31	2012	1
38	2012	2
31	2012	3
30	2012	4
31	2012	5
30	2012	6
30	2012	7
31	2012	8

[wonkymeister]

i should add that i've tried this hardcoded

=Sum({<Staff.Academic_Year={$(vYear)},Staff.Academic_Month = {$(vMaxPeriod)} >} 

  Number_of_Days_in_Period)

[manideep78]

Try this

Sum({$<Staff.Academic_Year={"$(=Max(Year))"},Staff.Academic_Month={''}>} No_of_Days_in_Period)

See attached qvw