hi .. please help
how can i get same output in qlikview?
below query i run in oracle & got result , i mention below?
what can i do in qlikview to get same result?
select job_id, avg(salary) from employees group by job_id having avg(salary)>
(select avg(salary)from employees group by job_id HAVING job_id='AC_MGR') ORDER BY JOB_ID;
output--
Job_ID , AVG(Salary)
AD_PRES 24000
AD_VP 17000
MK_MAN 13000
SA_MAN 12200