Expression Works But not in the script.

[pgalvezt]

Hello, I have this expression: =Sum({<DebtDays={'123456'}>}TotalDebt) Works Fine:

But in the script I put:

Est:
Load Num_Card_OP,

If(Sum(DebtDays= 123456),TotalDebt) as Estratificacion
 
resident table1
Group By Num_Card_OP;

Thanks.

[pgalvezt]

I know the requirement is very difficult. I don't know why in Excel it was more easy to get the results. The logic would be same that Excel-QlikView. But in QlikView dropped very different values (To High) But I appreciate the effort. I' am going to open another discussion with the resumen of this.

Thanks.