Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can we pass values to DB to get data accordingly

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),                                                                                      

                                                                

)  

3 Replies
swuehl
MVP
MVP

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.

santiago_respane
Specialist
Specialist

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,

Not applicable
Author

‌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.