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: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

any suggestion

shree909
Partner - Specialist II
Partner - Specialist II

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

thats the one way we can do it.

Anonymous
Not applicable
Author

thanks for your reply sree

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

pgalvezt
Specialist
Specialist

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

Hope Help you.