This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i want show same result in qlikview? mention below sql query what can i do?
whene i Execute below qury in oracle , got result so i want same result in qlikview please ans
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;
have you tried to run the query in qlikview?
You just need to put Sql query in Qlikview- Script Editor-Like Below.
Query: // Give TableName
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;
please not that you need to configure the source data-Oracle connection( basically setting up ODBC driver) with Qlikview first before executing it.
You can try like this:
LOAD * INLINE [
AVG(SAL) AS AVG_SAL
RESIDENT EMPLOYEES WHERE JOB_ID<>'AC_MGR'
GROUP BY JOB_ID;
AVG(SAL) AS AC_MGR_AVG_SAL
RESIDENT EMPLOYEES WHERE JOB_ID='AC_MGR'
RESIDENT EMPLOYEES2 WHERE AVG_SAL>$(VMGR);
DROP TABLES EMPLOYEES,EMPLOYEES2;
Thanks Sumanta. I got it
t.chetirbok ..... Thanks
Actually i loaded Oracle 10g HR Schema in Qlikview . I have four tables Employees,Job_History,Departments,Location
Data Model is OK or not ???
My question is that
just i want to show 4 record in pivot table
have you got my question ?