Problem Form

[pgalvezt]

Hello,

I have this in my script:

PorcentajeCalc:

Left Join (Junt)

Load Num_Tarjeta,

if(sum(DateDebt)= , FF1 * 0),

if(sum(DateDebt)>=1   And  sum(DateDebt)<=30, FF1 * 0,01) as RER

resident Junt

Group By Num_Tarjeta;

It seems * 0 and *0,01 is wrong. How can I put this formula in qlikview?

Thanks

[#2]

The problem I suspect is the , in 0,01

Try it like this:

PorcentajeCalc:

Left Join (Junt)

Load Num_Tarjeta,

if(sum(DateDebt)= , (FF1 * 0)),

if(sum(DateDebt)>=1   And  sum(DateDebt)<=30, (FF1 * 0.01)) as RER

resident Junt

Group By Num_Tarjeta;

[pgalvezt]

Hi, Thanks for your reply.

PorcentajeCalc:

Left Join (Junt)

Load Num_Tarjeta,

if(sum(DateDebt)= 'Date', (FF1 * 0)),

if(sum(DateDebt)>=1   And  sum(DateDebt)<=30, (FF1 * 0.01)) as RER

resident Junt

Group By Num_Tarjeta;

But Still Appears "Invalid Expression"

[MayilVahanan]

HI

Try like this

Left Join (Junt)

Load Num_Tarjeta,

if(sum(DateDebt)= 'Date', (FF1 * 0),

if(sum(DateDebt)>=1   And  sum(DateDebt)<=30, (FF1 * 0.01))) as RER

resident Junt

Group By Num_Tarjeta;

Hope it helps

[pgalvezt]

Hi, Appears the same error.

[MayilVahanan · Accepted solution]

Hi

     I think, You also include FF1 in group by..

[pgalvezt]

That was it.

Many Thanks.