Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stored procedure

Hello !

I have to import some Data from a Database. The Databas contains a big number of tables.
And I have to import some Data for making a nice BI for a client.
So far so good. But Im not realy keen in SQL, more in Controlling. But I realised there is

a stored procedure in my Database, which contains all my beloved data.
So I want to try to get the Data through the stored procedure.

But how to do, if you have no Idea ?
I read the related threads, but I couldn't solve the problem, with the containing information.

Is there out somebody which have easy examples, to become familiare  with Import of stored procedures

in Qlikview.


My stored procedure:

SQL DataBaseName.dbo.GetMarginOverview  '01.04.2011', '02.04.2011'

// The GetMarginOverview needs 2 Argumentes from and to (as Date).

// The Procedure is very complex, it contains 10 pages of SQL Statements

And the Procedure should return a big Table, with all related datas to show the margin of all products of the ERP System.


If there is some one with an Idea, how to come familiare, or with examples, or how to fix the problem, feel free

to post it.

Thanks in advance.

Werner Stiegler

2 Replies
prieper
Master II
Master II

Did you find an answer in the below Fred

http://community.qlik.com/message/115719#115719

?

Peter

Not applicable
Author

Mr. Peter !

Sorry this Fred (thread ... ) don't help me by my problem.
I had read also some other postings to this topic.

Thanks for the try ... :-).

By,

Werner