topic how to optimize this expression ? in QlikView

how to optimize this expression ?

Anonymous — Tue, 14 Aug 2012 14:06:42 GMT

Hello,

i have a expression such as multiple if statements which has a heavy impact on performance of my appilcation ..i just need to optimize this expression is there a way .below is my expression

if ( dimensionality() =1 , expression1),

if(dimensionality()=2, expression2),

if(dimensionality()=3, expression3),

if(dimensionality()=4, expression4,expression5))))

thanks

Re: how to optimize this expression ?

Anonymous — Tue, 14 Aug 2012 14:37:45 GMT

any suggestion

Re: how to optimize this expression ?

shree909 — Tue, 14 Aug 2012 14:48:45 GMT

U can write at the backend and make use of those expressiions at the front end.

thats the one way we can do it.

Re: how to optimize this expression ?

Anonymous — Tue, 14 Aug 2012 14:54:11 GMT

thanks for your reply sree

but no this is something needed in chart and i'm usung chart expression i.e AGGR()

Re: how to optimize this expression ?

pgalvezt — Tue, 14 Aug 2012 15:23:25 GMT

I think you have to use the IntervalMatch() Fuction into the script. Where dimensionality() is going to be your field.

Hope Help you.