topic Change in logic using dates in QlikView

Change in logic using dates

Fri, 26 Feb 2016 18:07:50 GMT

If(len(trim([K04 Date]))<>0,

if (not(Match( [Inv Grp],'FHA')),

(if(day([K04 Date])<=15,date(monthstart(addmonths([K04 Date],1))),date(monthstart(addmonths([K04 Date],2))))),

If(len(trim([K04 Date]))<>0,

if (Match( [Inv Grp],'FHA'),

(if(day([K04 Date])<=20,date(monthstart(addmonths([K04 Date],1))),date(monthstart(addmonths([K04 Date],3))))),

if([LM Workout Status Act]='IN TRIAL',[K04 Date],

This means that if a K04 date exists then if the investor group is not FHA and the date occurred within the first 15 days, advance 1 month, else advance 2 months. Do the same if the investor group is FHA except advance 1 and 3 months respectively.

Here is my issue: Now the FHA portion has been replaced by a completed 490,491 or 492. Does this mean the I now have to insert the if([LM Workout Status Act]='IN TRIAL',[K04 Date], after the first loop in the code only and could I define a date that encompasses all

3 dates mentioned and then use it in the second part of the code only???

load

if(len(trim([490]) <>0 or (len(trim([491]) <>0 or (len(trim([491])<>0, ????? as fha_date or something similar ???

in other words create this and load it prior to the code mentioned

Re: Change in logic using dates

sunny_talwar — Fri, 26 Feb 2016 18:30:43 GMT

Can you share a few lines of old data and few lines of new data to understand what has changed and provide you a solution

Re: Change in logic using dates

Fri, 26 Feb 2016 19:08:38 GMT

/*Current Data*/

load
If(len(trim([K04 Date]))<>0,
if (not(Match( [Inv Grp],'FHA')),
(if(day([K04 Date])<=15,date(monthstart(addmonths([K04 Date],1))),date(monthstart(addmonths([K04 Date],2))))),
/*if([LM Workout Status Act]='IN TRIAL',[K04 Date],*/
If(len(trim([K04 Date]))<>0,
if (Match( [Inv Grp],'FHA'), /*this must be altered*/
(if(day([K04 Date])<=20,date(monthstart(addmonths([K04 Date],1))),date(monthstart(addmonths([K04 Date],3))))),
if([LM Workout Status Act]='IN TRIAL',[K04 Date],

If(len(trim([367]))<>0,
if (not(Match( [Inv Grp],'FHA')),
(if(day([367])<=15,date(monthstart(addmonths([367],1))),date(monthstart(addmonths([367],2))))),
/*if([LM Workout Status Act]='IN TRIAL',[367]   ,*/
If(len(trim([367]))<>0,
if (Match( [Inv Grp],'FHA'), /*this must be altered*/
(if(day([367])<=20,date(monthstart(addmonths([367],1))),date(monthstart(addmonths([367],3))))),
if([LM Workout Status Act]='IN TRIAL',[367]

)))))))))) as [trial1_due_dt] ,

Now I need to alter the section marked, this must be altered. Essentially the K04 Date is replaced by a 490,491 or 492. Only one date will occur.

My questions are

Would I now need to insert the if([LM Workout Status Act]='IN TRIAL',[K04 Date], after the first 3 lines of code, currently commented out

Could I create a date function to handle the 490,491 and 492 and then pass it to the FHA portion of the code only