Aggr function in pivot

[#1]

Hey, guys!

I have a pivot with calculated dimension like: =aggr(IF(Rank(IF(Month_name>=(vCurMonth),Sum(Bench_Data*Forecast),Sum(Bench_Data)))<=5,Emp_name),Emp_name)

The expression is :IF(Month_name>=(vCurMonth),AVG(Bench_Data*Forecast),AVG(Bench_Data))

I also have a listbox with months, like Jan, Feb, Mar etc.

When i choose Mar it shows me top list of employees for March.

I was asked to change the formulas so whenever someone chooses March or other months it will show the values not only for March, but from January till March or other months.

Any ideas? Is it posible in qlikview?

Here is my sample data attached

[venkatraju]

Hi ,

I Have added extra table  in the script and used MonthSelector field name as filter in UI , hope it will sove your issue.

Please let me know if your expecting same ouptput.

I have attched the updated qvw.

Thanks

Venkat@

!

[#3]

Unfortunately, it's no what is needed...