Optimize expression

sathish_kumar — Sat, 16 Nov 2024 03:54:17 GMT

Hello Users,

Is there any way to optimize the below sum if /set analysis expression

The below expression works well in charts... need to replace with an optimized expression which consumes less RAM .

Is there any way you can fine tune below expression?

sum({<Date*={">$(vStart)<$(vEnd)"}>}Sales* if((1-(fabs(Sales-Estimate))/Sales)<0,0,(1-(fabs(Sales-Estimate))/Sales)))/sum({<Date*={">$(vStart)<$(vEnd)"}>} Sales)

I dont want to do it in scripts... so prefer it in expressions. So can someone help me with this...

@sunny_talwar

Re: Optimize expression

sunny_talwar — Wed, 10 Apr 2019 19:04:56 GMT

May be this

Sum({<Date*={">$(vStart)<$(vEnd)"}>}Sales * RangeMax((1-(fabs(Sales-Estimate))/Sales), 0))
/
Sum({<Date*={">$(vStart)<$(vEnd)"}>} Sales)

topic Optimize expression in QlikView

Optimize expression

Re: Optimize expression