Hi. I have created a dashboard which connects to our SQL Server. There are a number of stored procedures which I am using. This works fine when the document reloads - however, I am confused as to how I would refresh this information.
As far as I know, Qlikview will load all my data when the document loads. When I filter, the data loaded is filtered.. and not refreshed from the datasource.
I need to run stored procedures based on filters on my dashboard. My code at the moment is this
Hi - thanks for your reply. When I open the desktop qlikview application and open my qlikview document, it does the data load and passes default parameters to my stored procedures. I want to do the equivalent of reloading the stored procedure when I change a date parameter.
Is there an "onclick" event? I could then call a function/macro to refresh the data source? (Just the one stored procedure)