Optimization Qlikview Report

[Anonymous]

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.

[tresesco · Accepted solution]

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

[Anonymous]

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

But why i should try remove the Synthetic Keys ?

Sébastien.

[Chanty4u]

yes. chk dis

Removing Synthetic Keys

[tresesco]

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.

[Anonymous]

Ok, thank you for for help !

[Chanty4u]

chk

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

[pra_kale]

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.