3 Replies Latest reply: Nov 10, 2017 3:25 AM by Shraddha Gajare RSS

    Automate the process to export to excel

    Prashant Sancheti

      Hi Team,

       

      I have one requirement in Qlik Sense where i need to automate the process to exporting pivot table data to excel

      The Requirement is like

      1) Go to Folder
      2) Copy Previous Day Excel File
      3) Rename the file  ()
      4) Open the Excel File

      5) Clear the Data from Both Tab in Excel File

      6) Open QlikSense report having pivot table

      7) Export that data into excel automatically

      8) Format that excel

      9) Send an Email to user

      Could you please provide your input on how we can achieve this using QlikSense.