script

upaliwije — Tue, 14 Jul 2015 07:42:22 GMT

Hi friends

Pls help me to correct the following script. It does not show data as per slabs given in it. only first and last slab slow

if((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=10000 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10000, Dual('<=10000',1),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000), Dual('10,001-25,000',2),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=25001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=50000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-25001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-50000), Dual('25,001-50,000',3),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=50001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=500000)AND ((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-50001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-500000), Dual('50,001-500,000',4),
if(((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=500000 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-500000), Dual('Above 500,001',5))))))As NET_RANGE_WO_RF

Re: script

pokassov — Tue, 14 Jul 2015 09:00:14 GMT

Hello!

Check these conditions:

((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)

AND

((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000)

and try OR instead AND

((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=25000)

((RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))>=-10001 AND (RangeSum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))<=-25000)

topic Re: script in QlikView

script

Re: script