2 Replies Latest reply: Sep 14, 2017 12:56 PM by Chanty 4u RSS

    What happens when we change Data Source

    Ashok Yadav

      Hi Guys,

       

      I am developing QlikSense dashboard using excel sheets as data source however later part of the project i am going to change the data source to SQL or Amazon Redshift.

       

      I am not sure whether I can retain all of visualizations, calculated measures and variables. Or do I need to re-create the dashboard again?

       

      Ashok Yadav

        • Re: What happens when we change Data Source
          Anand Chouhan

          No you dont need to create change in the dashboard or in UI part. You have to just aware about the Tables names fields, Keys that you use also Metrics and dimension. When you change source better you create the QVDs of that because when you change the source of the Data you have to change it in the QVD makers it is good practice.

           

          Hope you understand the Qlikview architecture better way or you can learn about the Qlik architecture.

           

          Regards

          Anand

          • Re: What happens when we change Data Source
            Chanty 4u

            Hi As Anand Says....

             

            Just change the data source like creating the connection string

             

            and  load the same tables from DB  and just copy after the from path and replace the excel path in the script.

             

            and make sure that all the column names should be same .