Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

Straight table data load

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

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

There is a lot you can do...

You have unused tables, synthetic keys...

Look here:

Qlikview Best practices

View solution in original post

3 Replies
robert_mika
Master III
Master III

There is a lot you can do...

You have unused tables, synthetic keys...

Look here:

Qlikview Best practices

dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

Thanks Robert.

I will work on this

Thanks

Anil

robert_mika
Master III
Master III

You are welcome.

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