topic Re: Script calculation in QlikView

Script calculation

pgalvezt — Mon, 20 Oct 2014 17:15:04 GMT

Hello,

I have to do a caculation I think better from Script: I have 1 table called Real I need to calculate 2 lines (Same calculation of excel as example)

If([cc_group_desc ]='Dpto. Operaciones (Agrosystems)' and [cuenta ]='31020303' and Upper([subcuenta ])='' and [cc ]='4400','AB',

If([cc_group_desc ]='Dpto. Operaciones (Agrosystems)' and [cuenta ]='31020303' and Upper([subcuenta ])='' and [cc ]='4407','AB',

Each line brings a number. Example cc=4407 brings for January 7.565.000 and 4400 brings 0 for January.

The calculation is (Line 1 + Line 2) - Line 2 * 0.73513

It would be (0 + 7.565.000) - 7.565.000 * 0.73513 = 1.881.416( Final Calculation)

How to do this in the script?

Thanks!

pgalvezt — Mon, 20 Oct 2014 19:29:11 GMT

Hi,

Any help?

Thanks!

pgalvezt — Tue, 21 Oct 2014 12:22:22 GMT

Hi,

Anyone can help me with this?

Thanks!

miikkaqlick — Tue, 21 Oct 2014 13:33:34 GMT

Hi!

Try something like this:

=(Above(Sum({$<Detalle_EERR={'AB'}> }Real) *-1)+Sum({$<Detalle_EERR={'AB'}> }Real) *-1) - (Above(Sum({$<Detalle_EERR={'AB'}> }Real)) * 0.73513)

It needs more finishing, but I don't have time now.

Br,

Miikka