How can I make a stored procedure call after a user makes a selection?

[#1]

Hi all,

I'm building a dashboard that accesses a large amount of data.  The user in this case is only interested in specific data such as the following:
[Year]

[Model]

[Market]

Thus I would like the user to select these 3 (2015, Speedboat, North America), and then pass these as arguments into a stored procedure.  The results would then display in the graphs / metrics I'm calculating for those selected parameters.

Can this be done?  Any help with how?

Thanks!

[santiago_respane]

Hi Keithz,

i think it would be better for you to process all data from the stored procedure and load it into qlikview so when the user selects in those fields the result data is available faster. If you call the stored procedure each time the user makes a selection (if there's a nice way to do it) it will be very slow and you could end up in reloading the app multiple times, thing that might get the user bored.

Am i being clear?

Let me know if this helps.

Kind regards,

[#3]

Hi Santiago,

Thank you for your response!

In this case our database is a performance focused system that we are writing and tuning stored procedures for.  The user would only be interested in one combination of the above three parameters.  Our user for instance would be someone who is in charge of 2015 Speedboat sales in the US, for instance.  Thus, there won't be a use case for someone having to load the data again with different parameters.  (Another user might want to see this of course but they will still only make the call once).

I'm looking for something that takes input (from a listbox or something) and then passes it into the stored proc and loads the resultset.  Do I have to use triggers for this?

Thanks!

[luciancotea]

Solutions:

1. Load all data

2. Split the data between multiple qvw, jump from one to other

3. Use Direct Discovery

[santiago_respane]

This can be achieved in many ways, but when i came across a similar request i solved like this:

1- One listbox or input box per field (Year, Model, Market), if listbox make sure that only one selection at a time can be made.

2- One Button to process your data

2.1. When pressing the button it will store the selections made by the user (in my case user required excel file)

2.2. Triggers the reloading on server for the application

2.2.1. When reloading, if the excel file exists it will read it and pass the values to the stored procedure

3. When the reloading ends an alert appears in the screen so the user must refresh

Let me know if this helps or if you need more info.

Kind regards,