reduction of reload time - Qlik Community

manoj217 · ‎2017-10-16

i have used where condition during the reload time it takes 30 min to reload but i want to reduce the time without deleting the where condition how it is any suggestions plz

effinty2112 · ‎2017-10-16

Hi Manoj,

If you're using a preceding load and your WHERE statement is in the top LOAD statement you can perhaps take it out of there and write an equivalent WHERE statement in the SQL SELECT statement.

cheers

Andrew

PrashantSangle · ‎2017-10-16

can you share your script???

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MarcoWedel · ‎2017-10-25

Hi,

Please review your open threads and close those who received correct answers:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco