This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a SQL table with more than 3 lakh records and i need to pull datas based on condition.
in design level i have a input box when i enter some value say 'London' I need the customer details from london
ie i need to run the query "select * from cus where city = 'London'".
Thanks in advance
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.
If you do not want to do it that way you can try Direct Discovery if you're using QV11.2. Or you can try Partial Reload.
View solution in original post
Why would you like to pull the data using Dynamic SQL? Is there any reason behind it?