topic Contention between QlikView and MS Excel / Query ? in QlikView https://community.qlik.com/t5/QlikView/Contention-between-QlikView-and-MS-Excel-Query/m-p/299095#M1199415 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I am using QlikView 10 (free) personal edition.</P><P style="margin: 0cm 0cm 0pt;">I used MS Query via MS Excel to connect to the datasource so that I could form the SQL commands for the selection criteria to select the required dataset.</P><P style="margin: 0cm 0cm 0pt;">I copied the commands to QlikView.</P><P></P><P style="margin: 0cm 0cm 0pt;">QlikView did not return the dataset that I expected. The MS Excel query did return the expected dataset.</P><P style="margin: 0cm 0cm 0pt;">Only when I closed MS Excel did QlikView return the expected dataset.</P><P></P><P style="margin: 0cm 0cm 0pt;">This would indicate that there was some contention / locking of records, and that QlikView could not retrieve the records that were currently retrieved in MS Excel.</P><P></P><P style="margin: 0cm 0cm 0pt;">Can anyone educate me as to what is happening here.</P><P style="margin: 0cm 0cm 0pt;">Thanks in anticipation.</P><P></P><P style="margin: 0cm 0cm 0pt;">WE HAVE RESOLVED THIS ISSUE. IT WAS A POBLEM WITH THE SOURCE DATABASE.</P></BODY></HTML> Mon, 10 Jan 2011 18:41:33 GMT 2011-01-10T18:41:33Z Contention between QlikView and MS Excel / Query ? https://community.qlik.com/t5/QlikView/Contention-between-QlikView-and-MS-Excel-Query/m-p/299095#M1199415 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I am using QlikView 10 (free) personal edition.</P><P style="margin: 0cm 0cm 0pt;">I used MS Query via MS Excel to connect to the datasource so that I could form the SQL commands for the selection criteria to select the required dataset.</P><P style="margin: 0cm 0cm 0pt;">I copied the commands to QlikView.</P><P></P><P style="margin: 0cm 0cm 0pt;">QlikView did not return the dataset that I expected. The MS Excel query did return the expected dataset.</P><P style="margin: 0cm 0cm 0pt;">Only when I closed MS Excel did QlikView return the expected dataset.</P><P></P><P style="margin: 0cm 0cm 0pt;">This would indicate that there was some contention / locking of records, and that QlikView could not retrieve the records that were currently retrieved in MS Excel.</P><P></P><P style="margin: 0cm 0cm 0pt;">Can anyone educate me as to what is happening here.</P><P style="margin: 0cm 0cm 0pt;">Thanks in anticipation.</P><P></P><P style="margin: 0cm 0cm 0pt;">WE HAVE RESOLVED THIS ISSUE. IT WAS A POBLEM WITH THE SOURCE DATABASE.</P></BODY></HTML> Mon, 10 Jan 2011 18:41:33 GMT https://community.qlik.com/t5/QlikView/Contention-between-QlikView-and-MS-Excel-Query/m-p/299095#M1199415 2011-01-10T18:41:33Z Contention between QlikView and MS Excel / Query ? https://community.qlik.com/t5/QlikView/Contention-between-QlikView-and-MS-Excel-Query/m-p/299096#M1199416 <HTML><HEAD></HEAD><BODY><P> Have resolved this issue. It was a problem with the source database.</P></BODY></HTML> Thu, 21 Jul 2011 14:10:24 GMT https://community.qlik.com/t5/QlikView/Contention-between-QlikView-and-MS-Excel-Query/m-p/299096#M1199416 2011-07-21T14:10:24Z