Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am trying to convert a SQL Statement into a QlikView compatible statement can anybody please help
SQL Statement:
This currently calculates the number of Active employees at the end of a given period + the number of new starters in the period - the number of leavers in the period to give me the new balance of Active Employees
select
Count(CASE WHEN IsNull(EMPLOYEE.START_DATE, '1901-01-01') < '2012-06-01' And IsNull(EMPLOYEE.LEAVE_DATE,'2999-12-31') > '2012-06-30' THEN EMPLOYEE.EMP_CODE END) as [B/Fwd Active Employees (July)],
Count(CASE WHEN EMPLOYEE.START_DATE >= '2012-07-01' And EMPLOYEE.START_DATE <= '2012-07-31' THEN EMPLOYEE.EMP_CODE END) as [Employee Starters (July)],
Count(CASE WHEN EMPLOYEE.LEAVE_DATE >= '2012-07-01' And EMPLOYEE.LEAVE_DATE <= '2012-07-31' THEN EMPLOYEE.EMP_CODE END) as [Employee Leavers (July)],
Count(CASE WHEN IsNull(EMPLOYEE.START_DATE, '1901-01-01') < '2012-07-01' And IsNull(EMPLOYEE.LEAVE_DATE,'2999-12-31') > '2012-07-31' THEN EMPLOYEE.EMP_CODE END) as [C/Fwd Active Employees (July)]
from EMPLOYEE
I am trying to convert this to achieve the same either through the script or directly in a number of chart expressions
Kind Regard
Martyn
why can't you load the information into qlikview?
table:
load *;
sql [your SQL statment];
that way, you can fo not need to worry about converting(maybe?)