Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cseward1963
Contributor

Help with LOAD SCRIPT

Below is a portion of my load script:

CPCFile:

LOAD

    schoolid,

    therapistid,

    disciplineid,

    discipline,

    studentid,

    //tdate as DATE,

    date(tdate,'M/DD/YYYY') as DATE,

    "direct",

    IEPdirect,

    consult,

    consult*billrate as ConsultBilled,

    reeval,

    indirect,

    screen,

    eval,

    rti,

    other,

    individual,

    intervention,

    ei,

    billrate,

    schoolyear,

    grade,

    grpsz,

The BOLDED parts are billed hours.  grpsz can be NULL or an integer.   if grpsz = 1, then I want to add the value of IEPdirect to individual and then set IEPdirect=0 and "direct"=0.   Let me say that if grpsz has a value other than NULL, then IEPdirect and "direct" will be greater than 0(zero).

Any ideas for me?

Thanks

1 Reply
MVP
MVP

Re: Help with LOAD SCRIPT

May be like this?

If(grpsz = 1, IEPdirect + individual, individual) as individual,

If(grpsz = 1, 0, IEPdirect) as IEPdirect,

If(grpsz = 1, 0, direct) as direct