topic Re: Qlikview Optimization Techniques?? in QlikView

Qlikview Optimization Techniques??

rohitians — Wed, 12 Nov 2014 11:22:28 GMT

Dear All,

What are Qlikview Optimization Techniques kindly help me on the same.

Thanks and Regards,

Rohit Yadav

Wed, 12 Nov 2014 11:46:05 GMT

1. Don't use conditions on the QVD's like where and exists

2. Don't add an extra column's to the QVD's.

3. Don't use Joins, concatenate and Keeps rather than Joins you can use Apply map()

jyothish8807 — Wed, 12 Nov 2014 11:48:17 GMT

Hi,

this will be helpful

Regards

ashfaq_haseeb — Wed, 12 Nov 2014 11:49:42 GMT

Hi,

Check this too.

Regards

ASHFAQ

Wed, 12 Nov 2014 11:58:52 GMT

script level:

1)drop temp tables

2)use mapping if possible

3)try to avoid join

ui level:

1)write conditions instead of chart in script level it self

2)observe the memory consumption of cahrts to populate

server level:

distributing the content for users. based