topic Re: Aggr function in pivot in QlikView

Aggr function in pivot

Mon, 20 Apr 2015 08:51:45 GMT

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

Re: Aggr function in pivot

venkatraju — Mon, 20 Apr 2015 11:03:45 GMT

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@

Re: Aggr function in pivot

Mon, 20 Apr 2015 13:41:47 GMT

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