Converting SQL CASE statement

Tue, 02 Oct 2012 15:29:50 GMT

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

Re: Converting SQL CASE statement

alexpanjhc — Tue, 02 Oct 2012 19:51:45 GMT

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?)

topic Converting SQL CASE statement in QlikView

Converting SQL CASE statement

Re: Converting SQL CASE statement