Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

srikanthsri1
Valued Contributor

how to optimize this expression ?

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

4 Replies
srikanthsri1
Valued Contributor

Re: how to optimize this expression ?

any suggestion

shree909
Valued Contributor II

Re: how to optimize this expression ?

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

thats the one way we can do it.

srikanthsri1
Valued Contributor

Re: how to optimize this expression ?

thanks for your reply sree

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

pgalvezt
Valued Contributor

Re: how to optimize this expression ?

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

Hope Help you.

Community Browser