Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

question

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

0 Replies