topic Re: Re: Re: If Problem in QlikView

If Problem

pgalvezt — Tue, 28 Jan 2014 19:57:51 GMT

Hello,

I have calculated a formula but I stuck:

Sum(Aggr(

if(Column(8) = 0,

If(Column(6) > 0,

If((aggr(Sum(cantidad_oh),articulo) - aggr(Sum(patrimonio),articulo)) > Column(6),

If((aggr(Sum(cantidad_oh),articulo) - aggr(Sum(patrimonio),articulo)) <= (2*Column(6)),

(((Sum(cantidad_oh) - Sum(patrimonio)) - Column(6))), Column(6)),'0'),'0'),'0'),articulo))

The result gives nothing just a 0.

Thanks!

Re: If Problem

Tue, 28 Jan 2014 20:03:46 GMT

Hey Pablo,

Is it possible to attach a dummy file with some sample data.

Thanks

Re: Re: If Problem

pgalvezt — Tue, 28 Jan 2014 20:21:56 GMT

Hi,

Sure, Here is the attached. I just almost get all columns. The rest is just Column(A) * Column(B)

Thanks!

Re: Re: Re: If Problem

Anonymous — Tue, 28 Jan 2014 20:37:08 GMT

Hi Pablo,

I thought we've solved a similar problem already - I had to replace references to columns with actual expressions. See attached with your new problem fixed.

(I also moved totals on top to avoid scrolling)

Regards,

Michael