topic Re: If statements in load script in QlikView

If statements in load script

Mon, 17 Sep 2012 20:41:04 GMT

I'm new to Qlikview - at least developing scripts and I need to put in three If statements in my load script.

The next three lines are each line I need to calculate in the script:

Effective Date + 365 days as Renewal,

Effective Date <= 365 days AND Agent First Application Date <= 365 days as First Year New Agent,

Effective Date <= 365 days AND Agent First Application Date >= 365 days as First Year Existing Agent

I read the initial code as an If statement within the load as IF(Effective Date + 365 Days, __) as Renewal - is there any values I'd put in the THEN part or do I leave that alone?

Thanks in advance.

Re: If statements in load script

MayilVahanan — Mon, 17 Sep 2012 20:52:05 GMT

Just leave as it is..date(EffectiveDate+365) as Renewal

Can you say Effective Date <= 365 means? Any thing you compare it?

Re: If statements in load script

Mon, 17 Sep 2012 21:34:45 GMT

Sure. The Effective Date is within a year and the First Application Date is also within a year of the first application date - resulting in a new agent.

If the First Application Date is over a year, then it's an existing agent.

Re: If statements in load script

MayilVahanan — Mon, 17 Sep 2012 21:59:20 GMT

Effective date and first application date are numbers?

If so, Can you provide a sample numbers?

I think, some thing like

Load * ,

Date(Effective Date+365) as Renewal,

if(Num(today()) -num(Effective Date) <= 365 AND Num(today())-num(Agent First Application Date) <= 365,'First Year New Agent',

if(Num(today()) -num(Effective Date) <= 365 AND Num(today()) -num(Agent First Application Date)>= 365,' First Year Existing Agent')) as Agents

From tableName;

Hope that helps