Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

improve performance time response

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 ?

2 Replies
simenkg
Specialist
Specialist

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

?

Anonymous
Not applicable
Author

I have two year fields

1.png