3 Replies Latest reply: Aug 18, 2017 8:38 AM by Felip Drechsler RSS

    Qlik Sense Load SP based on other SP result

    Miguel Cunha

      Hello guys,

       

      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:

       

      Load SP_stores;
           For each ID in

                LOAD

                *;

                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,

       

      Miguel Cunha