Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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@
!
Unfortunately, it's no what is needed...