topic Re: Script-Logic in QlikView

Script-Logic

dhanu_today — Wed, 05 Mar 2014 17:32:11 GMT

Hi Everyone,

I have wrote all the logics in set analysis level in front end level.But for further process we have to do the calculations in script itself mandatorly

Logics:

I have to show the fields when the below conditions are matched and here attached the sample data.

accountopeningdate = max(period) and Flag=N and B-product=CA,SA as CASA

accountopeningdate = max(period) and Flag=N and B-product=FD and Balance >=250000 as FD

accountopeningdate -= max(period) and Flag=N as YF(i.e the accounts which are not open in max(period))

Thanks in advance,

Dhanu

Re: Script-Logic

MK_QSL — Wed, 05 Mar 2014 17:38:09 GMT

Are you talking about Max(Period) one for whole data set or per ID?

Re: Script-Logic

dhanu_today — Wed, 05 Mar 2014 17:39:18 GMT

Thanks for your quick reply.Its per id wise Data set.

Re: Script-Logic

MK_QSL — Wed, 05 Mar 2014 17:55:18 GMT

TEMP:

LOAD ID,

AccountNO,

AOD,

SRM,

Custid,

LSRM,

Product,

[B-Product],

Date(Period) as Period,

Flag,

Balance

FROM

TableName;

Left Join

Load Date(Max(Period)) as MaxPeriod Resident TEMP;

NoConcatenate

Load AOD as CASA Resident TEMP

Where Period = MaxPeriod and

Flag = 'N' and

Match([B-Product],'CA','SA');

NoConcatenate

Load IF([B-Product]= 'fd',AOD) as FD Resident TEMP

Where Period = MaxPeriod and

Flag = 'N' and

Balance >= 25000;

NoConcatenate

Load AOD as YF Resident TEMP

Where Period <> MaxPeriod and

Flag <> 'N';