Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Let's say I have a sql stored procedure that can return me a dataset with a variable number of columns:
Any suggestions?
-ed
Hi Ed,
In regards to your first question, you do can execute a stored procedure and load its results into QlikView:
Table:
LOAD *;
SQL EXEC sp_procname;
What do you mean by "bid it to a straight table"? Once you have the fields loaded into QlikView you can create a chart straight table, and use these fields in the Dimensions and Expressions tabs of the chart properties.
Hope that helps.
BI Consultant
Thanks for the help Miguel, #2 was more like, "How can I build a chart straight table with a dynamic number of columns", since the datasource can have X number of columns, my chart would have to reflect it.
Do you know a way to append columns dynamically?
Thanks again for you time.
-ed
Ed,
You can actually build a table from the scratch using the QlikView API and a macro triggered from a button or a textbox. However, I don't recommend you to do that if possible, and instead, create a pivot table where the expressions and dimensions can be moved to a horizontal position if needed, so if you dimension increases, so your chart will do. Anyway, without more details on your requirements, expected output and datamodel is hard to say.
Regards.
BI Consultant
Thanks again Miguel, about the requirement, I also have little information, mostly is that, can I create a Straight table and add columns to it, depending on the number of columns that the stored proc returned?
I have read a lot here in the forum, but all negative answers, I wanted to ask it myself, but since you mentioned a macro, I was told nto to use them, so basically I ended were I started, do you agree?
-ed