if statement

josephinetedesc — Mon, 15 Jun 2015 15:12:56 GMT

this is what I want to do in QlkView script

IF(

condition1. if statusNumber <20, give stsNumber,

condition 2. if statusNumber is null (or text - this picks up the NULL from SQL), give stsNumber of 0

condition 3. (if the date and the id number is the same), and (there are 2 or more statusNumbers) -, give the smallest stsNumber)

AS stsNumberGiven

The third conditions is the only condition where the there will be more than 1 statusNumber

Any help greatly appreciated - I have exhausted my skill set

Re: if statement

sunny_talwar — Mon, 15 Jun 2015 15:38:56 GMT

From what I understand, the below might be useful (you may need to adjust it based on your need):

Table:

LOAD yourFiels,

statusNumber,

stsNumber,

date,

idNumber

FROM Source;

Join(Table)

LOAD date,

idNumber,

statusNumber,

Min(stsNumber) as MinstsNumber
Resident Table

Group By date, idNumber, statusNumber;

TableFinal:

LOAD *,

If(Len(Trim(statusNumber)) = 0 or IsText(statusNumber), 0, MinstsNumber) as srsNumberGiven

Resident Table;

DROP Table Table;