topic Optimization Qlikview Report in QlikView

Optimization Qlikview Report

Anonymous — Fri, 08 Apr 2016 07:01:26 GMT

Hello,

I am a beginner on Qlikview and i want to optimize my report, because sometimes it tasks approximately 15 minutes to import all the tables from my Access Database.

I use SQL command to import all the data, can i use a LOAD function ? is it more powerful ?

Find attached my structure project:

Have you got a idea to optimize it ? I don't understand how i can do that ...

Thanks your in advance for your help,

Sébastien.

Re: Optimization Qlikview Report

tresB — Fri, 08 Apr 2016 07:09:12 GMT

It's not about LOAD or SQL. It's about Synthetic Keys getting generated in your data model. You should ideally try to remove them from the model. Search this forum, you would get many threads suggesting about the same, like: Synthetic Keys

Re: Optimization Qlikview Report

Anonymous — Fri, 08 Apr 2016 07:11:28 GMT

Ok, thank you for your response and i will check this

But why i should try remove the Synthetic Keys ?

Sébastien.

Re: Optimization Qlikview Report

Chanty4u — Fri, 08 Apr 2016 07:11:55 GMT

yes. chk dis

Removing Synthetic Keys

Re: Optimization Qlikview Report

tresB — Fri, 08 Apr 2016 07:14:53 GMT

Most likely, your data reload is taking long because of them. Go through the thread I shared, it would probably answer your this query too.

Re: Optimization Qlikview Report

Anonymous — Fri, 08 Apr 2016 07:17:00 GMT

Ok, thank you for for help !

Re: Optimization Qlikview Report

Chanty4u — Fri, 08 Apr 2016 07:18:36 GMT

chk

https://community.qlik.com/message/783807#783807

Re: Optimization Qlikview Report

pra_kale — Fri, 08 Apr 2016 07:20:55 GMT

Hi,

If more than one column linked between two tables its create sythetic key.

you can remove it using qualify/unqualify.

qualify all the fields

and unqulify the key field.