question

[Anonymous]

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