topic Re: error in expression Sum-if in QlikView

error in expression Sum-if

Mon, 09 Jul 2012 16:52:29 GMT

Can somebody explain me why this formula does'nt work and show the error mesage:

sum(if(Finalizada_Act =1 and sum(CantidadCont)-Sum(Aggr(Cantidad_Act, ActividadId_TTD))<>0,1,0))

And what will be the correct one. Thanks in advance.

Pat.

MayilVahanan — Mon, 09 Jul 2012 16:59:36 GMT

Hi,

Try this,

= sum(if(Finalizada_Act =1 and (sum(CantidadCont)-Sum(Aggr(Sum(Cantidad_Act), ActividadId_TTD))<>0),1,0))

Check the value in text box - > Sum(Aggr(Sum(Cantidad_Act), ActividadId_TTD))

Hope it helps

Mon, 09 Jul 2012 17:10:16 GMT

Hi Mayil,

that doesn't work eather. The problem is that in both formula, the edit expresion box told me thet there is an error in expression.

Mon, 09 Jul 2012 17:22:01 GMT

Hi,

no, it show the same message, the brackets are not the problem.

Mon, 09 Jul 2012 17:29:53 GMT

The following sentence is working:

if((sum(CantidadCont))-(Sum(Aggr(Cantidad_Act, ActividadId_TTD)))<>0,1,0)

But when I want to sum, it does'nt work and show an error in expresion:

Sum(if((sum(CantidadCont))-(Sum(Aggr(Cantidad_Act, ActividadId_TTD)))<>0,

1,0))

MayilVahanan — Mon, 09 Jul 2012 17:52:57 GMT

Hi,

Sum(if(Finalizada_Act =1 and (CantidadCont - (Aggr(Sum(Cantidad_Act), ActividadId_TTD)))<>0,1,0))

Hope it helps

Mon, 09 Jul 2012 17:57:35 GMT

You're a genius, thank you very much.