topic Re: uploading excel data to qv desktop in QlikView https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632032#M231913 <HTML><HEAD></HEAD><BODY><P>Load your excel in the parts</P><P></P><P>1. Divede it in the dimensions like Year, Month, Region, SalesRep, Country.</P><P>2. Load your excel with minimum rows or less data to check the data model.</P><P>3. After data get loaded check the primary keys and foreign key combinations among the tables.</P></BODY></HTML> Thu, 29 May 2014 07:16:37 GMT its_anandrjs 2014-05-29T07:16:37Z uploading excel data to qv desktop https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632030#M231911 <HTML><HEAD></HEAD><BODY><P>i have around 45 excels and data upto 280 mb which i need to upload in qv desktop,but during excution its taking lot of time and thn it hangs and stop working ,what can be done,kindly guide??</P></BODY></HTML> Thu, 29 May 2014 07:08:15 GMT https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632030#M231911 2014-05-29T07:08:15Z Re: uploading excel data to qv desktop https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632031#M231912 <HTML><HEAD></HEAD><BODY><P>1) try to understand which xlsx is critical</P><P>2) try to split this (or these) xlsx in more files (by months, by date, by customers ....)</P><P></P><P>Let mre know</P></BODY></HTML> Thu, 29 May 2014 07:10:07 GMT https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632031#M231912 alexandros17 2014-05-29T07:10:07Z Re: uploading excel data to qv desktop https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632032#M231913 <HTML><HEAD></HEAD><BODY><P>Load your excel in the parts</P><P></P><P>1. Divede it in the dimensions like Year, Month, Region, SalesRep, Country.</P><P>2. Load your excel with minimum rows or less data to check the data model.</P><P>3. After data get loaded check the primary keys and foreign key combinations among the tables.</P></BODY></HTML> Thu, 29 May 2014 07:16:37 GMT https://community.qlik.com/t5/QlikView/uploading-excel-data-to-qv-desktop/m-p/632032#M231913 its_anandrjs 2014-05-29T07:16:37Z