topic Re: Straight table data load in QlikView https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202260#M874382 <HTML><HEAD></HEAD><BODY><P>There is a lot you can do...</P><P></P><P>You have unused tables, synthetic keys...</P><P></P><P></P><P>Look here:</P><P><A href="https://community.qlik.com/thread/39646">Qlikview Best practices</A></P></BODY></HTML> Mon, 31 Oct 2016 23:35:33 GMT robert_mika 2016-10-31T23:35:33Z Straight table data load https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202259#M874381 <HTML><HEAD></HEAD><BODY><P>Hello Qlik developers</P><P>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.</P><P></P><P>Thanks</P><P>Anil Danda</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202259#M874381 dandaanilreddy 2020-11-25T16:16:04Z Re: Straight table data load https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202260#M874382 <HTML><HEAD></HEAD><BODY><P>There is a lot you can do...</P><P></P><P>You have unused tables, synthetic keys...</P><P></P><P></P><P>Look here:</P><P><A href="https://community.qlik.com/thread/39646">Qlikview Best practices</A></P></BODY></HTML> Mon, 31 Oct 2016 23:35:33 GMT https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202260#M874382 robert_mika 2016-10-31T23:35:33Z Re: Straight table data load https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202261#M874383 <HTML><HEAD></HEAD><BODY><P>Thanks Robert.</P><P>I will work on this <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks</P><P>Anil</P></BODY></HTML> Mon, 31 Oct 2016 23:38:50 GMT https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202261#M874383 dandaanilreddy 2016-10-31T23:38:50Z Re: Straight table data load https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202262#M874384 <HTML><HEAD></HEAD><BODY><P>You are welcome.</P><P>Please come back once you clean your model and you will required more assistance.</P></BODY></HTML> Mon, 31 Oct 2016 23:41:33 GMT https://community.qlik.com/t5/QlikView/Straight-table-data-load/m-p/1202262#M874384 robert_mika 2016-10-31T23:41:33Z