Straight table data load

[dandaanilreddy]

Hello Qlik developers

I have a straight table in which i have 6 dimension and one expression i.e sum(amount) and total rows is 80k. When i make any selection the table is taking long time to load the data. Please find the attached image of data model. The territory is the common key for most of the tables. Is there anything i have to make changes in my data model? Can someone help me please.

Thanks

Anil Danda

[robert_mika · Accepted solution]

There is a lot you can do...

You have unused tables, synthetic keys...

Look here:

Qlikview Best practices

[dandaanilreddy]

Thanks Robert.

I will work on this

Thanks

Anil

[robert_mika]

You are welcome.

Please come back once you clean your model and you will required more assistance.