topic Re: Form Script in QlikView

Form Script

pgalvezt — Tue, 31 Jul 2012 20:11:26 GMT

How Should read into my sxript this?

if(aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)= TDFECPRO, Debt * 0,

if(aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)>=1 And aggr(sum(date(TDFECPRO)-TD_Mora),Num_Tarjeta)<=30, Debt * 0.01))

I tried:

if(sum(TDFECPRO - TD_Mora)= 'TDFECPRO',Debt * 0),

if(sum(TDFECPRO - TD_Mora)>=1 And sum(TDFECPRO - TD_Mora)<=30, Debt * 0.01) as RER

But Nothing Happens.

Thank you

Re: Form Script

pljsoftware — Tue, 31 Jul 2012 23:06:01 GMT

Hi,

have you try to use Group By in your script?

Load

.....

if(....) as RER

Resident Table

Group By Num_Tarjeta

Regards

Luca Jonathan Panetta

PLJ Software

Re: Form Script

sebastiandperei — Tue, 21 Aug 2012 10:38:10 GMT

Pgalvez, if I understand, you need to put these expression in a field in the script. Please, say me if im wrong.

For do that, you (or we, to help you) need to know the data structure and format. Many times, the data isn't related in the tables like are in the expressions, of the final app.

Could you send us a reduced copy?