Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Can we pass values to DB to get data accordingly in qlikview
for instance,
alter Test [dbo].[Report1]-- [Report1] '','5243','81','',''
(
@Column1 VARCHAR(500),
@Column2 VARCHAR(max),
@Column3 VARCHAR(max),
@Column4 VARCHAR(500),
@Column5 VARCHAR(max),
)
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.
Hi Bob,
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.
Kind regards,
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.