Can we pass values to DB to get data accordingly in qlikview
alter Test [dbo].[Report1]-- [Report1] '','5243','81','',''
Might be possible.
Open the connection in read and write mode (see Settings tab in script editor dialog), then send your code using SQL statement first.
what do you mean by that, pass parameters to a db stored procedure? execute a ddl in database via qlikview?
Please elaborate more in order to help you.
Hi Santiago, I have a requirement where I have to initially pass couple of values to DB and then based on the values passed DB will respond with the according Data set with which I have to write logic and perform analytics.
Retrieving data ...