topic Re: Performance in QlikView

Performance

Anonymous — Thu, 30 Apr 2015 05:33:49 GMT

Hi All,

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);

Thanks

Re: Performance

sagarkharpude — Thu, 30 Apr 2015 05:41:11 GMT

You can convert date from string to number format by using date# function and then monitor the performance.

Re: Performance

jagan — Thu, 30 Apr 2015 05:53:39 GMT

Hi,

Is it SQL query or Qlikview Load script?

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.

Regards,

jagan.

Re: Performance

Anonymous — Thu, 30 Apr 2015 05:59:54 GMT

Thanks for reply Jagan ,

Its qlikview load script .