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.

[MayilVahanan]

Hi

Try like this,

Load Num_Card_OP,

If(DebtDays= '123456',Sum(TotalDebt)) as Estratificacion 
resident table1

Groupby

TotalDebt , Num_Card_OP;

Hope it helps

[pgalvezt]

Thanks for your reply: Works but drop many values with my expression I get just one total. Miss something?

[MayilVahanan]

HI

     Its calculate the value for DebtDays= '123456'.. and take value(TotalDebt) for that.What is your requirement

[#5]

You can also flag records (in the script) that have DebtDays = '123456' and then use the flag in your set analysis. that way you'll have both DebtDays and non-DebtDays values.

[pgalvezt]

The requirement is get phases for debt days (Debt Days = DateDebt - endMonth).So

If debt days = 123456 1-30 days,

If debt days =123456789 31-60 and so on. I left a QlikView file for better comprehenssion. Finally I have to build a table with Stratos by Total debt for sectors.

[pgalvezt]

Any Help please

Thanks.

[pgalvezt]

Could you please put an example?

[pgalvezt]

I tried:

If

(DiasMora = 41060, Dual('Al Día',1),
If(DiasMora >= 1 And DiasMora <=30, Dual('1-30 Días',2))) as Estratificacion

But QlikView drop a Aggregation Problem.

[MayilVahanan]

HI

     in this,

Estratificacion:

Load Num_Tarjeta_OP,

if(DiasMora = 41060, sum(Deuda_Total)) as Estratificacion

//If(DiasMora = 41060, Dual('Al Día',1)) as Estratificacion

/*if(sum(DiasMora)>=1   And  sum(DiasMora)<=30,  Dual('1-30  Días',2),

if(sum(DiasMora)>=31  And  sum(DiasMora)<=60, Dual('31-60 Días',3),

if(sum(DiasMora)>=61  And  sum(DiasMora)<=90,Dual('61-90 Días',4),

if(sum(DiasMora)>=91  And  sum(DiasMora)<=120,Dual('91-120 Días',5),

if(sum(DiasMora)>=121  And  sum(DiasMora)<=150, Dual('121-150 Días',6),

if(sum(DiasMora)>=151  And  sum(DiasMora)<=180, Dual('151-180 Días',7),

if(sum(DiasMora)>=181  And  sum(DiasMora)<=210,Dual('181-210 Días',8),

if(sum(DiasMora)>=211  And  sum(DiasMora)<41029, Dual('>211 Días',9)))))))))) as Estratificacion*/          

resident Cartera

Group By Deuda_Total,Num_Tarjeta_OP;

sum(DiasMora) value?