Who to write expression in optimize way

kunkumnaveen — Mon, 28 Jun 2021 09:30:42 GMT

Hello All,

I have written a expression with plenty of IF conditions in it and it is doing the purpose, but when I look it I personal feel that it can be written in more optimize way

Kindly suggest me how can I write the below expression in more optimize way instead of IF conditions

if(SubStringCount([Measure for Filter],'ABSRPT'),
if('$(vComparison)'='8', sum([Impact]),
if(vComparison=1,
if(Num(sum([ABSRPT]), '#,##0.##', '.' , ',' )=Num($(vThresholdValue), '#,##0.##', '.' , ',' ),sum([Impact])),

if(vComparison=2,
if(sum([ABSRPT])<>$(vThresholdValue),sum([Impact])),

if(vComparison=3,
if(sum([ABSRPT])>$(vThresholdValue),sum([Impact])),

if(vComparison=4,
if(sum([ABSRPT])>=$(vThresholdValue),sum([Impact])),

if(vComparison=5,
if(sum([ABSRPT])<$(vThresholdValue),sum([Impact])),

if(vComparison=6,
if(sum([ABSRPT])<=$(vThresholdValue),sum([Impact]))

)))))))

Note: Copying only a piece of lines from my 143 line expression hoping that if i fix this i can fix the rest tooo

Thanks

Re: Who to write expression in optimize way

kunkumnaveen — Mon, 28 Jun 2021 11:13:03 GMT

Any suggestion Plz how can I write the above expression in a optimize way I mean with less IF conditions

topic Who to write expression in optimize way in QlikView

Who to write expression in optimize way

Re: Who to write expression in optimize way