I need to cut down the execution time where my script fetches data based on nelow condition.Are there any way to rewrite the below condition to increase the performance .
where
num(SALESDATE) >= $(START_DATE) and num(SALESDATE) <= $(END_DATE);
If it is SQL Query then creating Index on SALESDATE field will improve the performance.
If it is Qlikview Script, then convert the SALESDATE field to number when you are data in the QVD itself.
Generally Qlikview runs in Superfast mode but when you put where condition it runs in normal mode. Since you need the condition to be implemented you have to use this.
