topic improve performance time response in QlikView

improve performance time response

Anonymous — Mon, 05 Oct 2015 12:18:36 GMT

I have a QVW in which there are two many IFS

expression for example

=if(IsNull(GetFieldSelections(Week,'*')),Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC]),Sum({$<Weekyear= {$(=max(Weekyear))}>}[Prix de vente TTC]))

Is there a way to include this expression as variable that I can use it wherever I need it ?

Is there anothor way to improve performance ?

Re: improve performance time response

simenkg — Mon, 05 Oct 2015 12:21:21 GMT

Cant you just change this expression to
Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC])

Re: improve performance time response

Anonymous — Mon, 05 Oct 2015 12:25:40 GMT

I have two year fields