topic Transform if in set Analysis in QlikView

Transform if in set Analysis

Wed, 21 Mar 2012 10:18:45 GMT

Count( if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1), employee_id,0))

How can put this in Set analysis ?

Thx,

Transform if in set Analysis

jvitantonio — Wed, 21 Mar 2012 11:11:41 GMT

Hi try this:

count( {$<date_start = {>=date(vdateNum)}, date_etabl = {>=date(vdateNum), NULL}, date_branch = {>=date(vdateNum), NULL} >} employee_id)

Transform if in set Analysis

Wed, 21 Mar 2012 11:14:52 GMT

Hi,

You can do this by using flags.

Make a flag in you script like:

if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1),1,0) as Flag

succes,

Halmar

Transform if in set Analysis

Wed, 21 Mar 2012 11:16:14 GMT

Thanks !!