topic Re: Problem Form in QlikView

Problem Form

pgalvezt — Thu, 02 Aug 2012 14:42:58 GMT

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

Re: Problem Form

Thu, 02 Aug 2012 14:45:16 GMT

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;

Re: Problem Form

pgalvezt — Thu, 02 Aug 2012 15:23:28 GMT

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"

Re: Problem Form

MayilVahanan — Thu, 02 Aug 2012 15:29:00 GMT

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

Re: Problem Form

pgalvezt — Thu, 02 Aug 2012 16:13:36 GMT

Hi, Appears the same error.

Re: Problem Form

MayilVahanan — Thu, 02 Aug 2012 16:21:33 GMT

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

Re: Problem Form

pgalvezt — Thu, 02 Aug 2012 16:53:07 GMT

That was it.

Many Thanks.