Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
techvarun
Valued Contributor II

SQL Dynamic data

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: SQL Dynamic data

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.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: SQL Dynamic data

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.


talk is cheap, supply exceeds demand

View solution in original post

multiview
Contributor II

Re: SQL Dynamic data

Why would you like to pull the data using Dynamic SQL? Is there any reason behind it?

Regards

MultiView