This content has been marked as final. Show 3 replies
I have two stored procedures: the first one results in a list of all stores of a company, having ID and Name.
The second one returns all the sales of the company having storeID, TransactionID and value.
The second SP receives as parameter the storeID.
Is is possible to load the first stored procedure and for each store that it returns, use it to load the second stored procedure usign the storeID?
I'd like to make something like this:
For each ID in
SQL exec SP_Stores;
SQL exec SP_Salles ID;
As I am new in qlik I'm not sure about the nomenclature.
Is this possible? Can you please help me?
NOTE: The tables i'm using are way more complex, but I made them this way just to make it easier to understand.
Thanks in advance,