QlikView App - Script Question

[SNarendran]

Hi,

Question related to bringing in data from SQL and creating an Qlikview App. requirements are as follows:

 - Fields from my sql server database are :

-  Listing Number

-  Street Name

- Street Number

- Apt/Unit

- City

 - Postal Code

- Sold  Date

I need to be able to develop an app that lets the user enter values in the address fields and identify a Listing Number.

This Listing number will have a corresponding sold date.

The user should then be shown a table with other Listings within 90 days of the sold date of the identified above-noted Listing.

Do i bring in the entire data set and let the user select the address values from List boxes?

Your suggestions are appreciated.

Thanks

Shashank

[Brett_Bleess]

I would venture you are on the right track, you could consider an Input Box and variable to try to narrow the list box selections that are 'available' to the users, that might help them, but the other way to go at it could be to create a Master Calendar and let them select date or range there etc. and use that to narrow down things too.  Here is a Design Blog post on the Master Calendar concept:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

If you wish to search the Design Blog area further for other ideas, here is the URL to do that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully this gets you started with things.  It may help if you can load up what you have into a QVW and attach that, so folks can see the data model etc., sometimes that makes it easier to provide ideas.

Regards,
Brett