topic Re: SQL Dynamic data in QlikView https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483802#M555436 <HTML><HEAD></HEAD><BODY><P>The Qlikview way is to load all 3 lakh records and use a listbox to filter the data. That is faster and more flexible than any alternative. </P><P></P><P>If you do not want to do it that way you can try <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/previewBody/3710-102-1-4293/QlikView 11 2 Direct Discovery Technical Addendum.pdf">Direct Discovery</A> if you're using QV11.2. Or you can try <A _jive_internal="true" href="https://community.qlik.com/message/287233#287233">Partial Reload</A>.</P></BODY></HTML> Mon, 12 Aug 2013 09:06:20 GMT Gysbert_Wassenaar 2013-08-12T09:06:20Z SQL Dynamic data https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483801#M555435 <HTML><HEAD></HEAD><BODY><P>I have a SQL table with more than 3 lakh records and i need to pull datas based on condition.</P><P></P><P><BR />in design level i have a input box when i enter some value say 'London' I need the customer details from london</P><P></P><P>ie i need to run the query "select * from cus where city = 'London'". </P><P></P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Mon, 12 Aug 2013 08:48:18 GMT https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483801#M555435 techvarun 2013-08-12T08:48:18Z Re: SQL Dynamic data https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483802#M555436 <HTML><HEAD></HEAD><BODY><P>The Qlikview way is to load all 3 lakh records and use a listbox to filter the data. That is faster and more flexible than any alternative. </P><P></P><P>If you do not want to do it that way you can try <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/previewBody/3710-102-1-4293/QlikView 11 2 Direct Discovery Technical Addendum.pdf">Direct Discovery</A> if you're using QV11.2. Or you can try <A _jive_internal="true" href="https://community.qlik.com/message/287233#287233">Partial Reload</A>.</P></BODY></HTML> Mon, 12 Aug 2013 09:06:20 GMT https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483802#M555436 Gysbert_Wassenaar 2013-08-12T09:06:20Z Re: SQL Dynamic data https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483803#M555437 <HTML><HEAD></HEAD><BODY><P>Why would you like to pull the data using Dynamic SQL? Is there any reason behind it? </P><P></P><P>Regards</P><P>MultiView</P></BODY></HTML> Mon, 12 Aug 2013 09:16:56 GMT https://community.qlik.com/t5/QlikView/SQL-Dynamic-data/m-p/483803#M555437 Anonymous 2013-08-12T09:16:56Z