Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

script

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

1 Reply
pokassov
Specialist
Specialist

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)

    OR

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