topic Re: Set Analysis – summing value depending on selected periods in QlikView

Set Analysis – summing value depending on selected periods

wonkymeister — Tue, 05 Mar 2013 11:36:51 GMT

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

Re: Set Analysis – summing value depending on selected periods

wonkymeister — Tue, 05 Mar 2013 11:38:24 GMT

i should add that i've tried this hardcoded

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

Number_of_Days_in_Period)

Re: Set Analysis – summing value depending on selected periods

manideep78 — Tue, 05 Mar 2013 11:52:28 GMT

Try this

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

See attached qvw