4 Replies Latest reply: May 24, 2017 10:33 AM by Charlie Audebert RSS

    Comparing data

    Charlie Audebert

      Hi,

       

      I've a dataset of projects with their caracteristics wich is updated every week and I use it to show the evolution since the beginning of the year. The columns are the same every week but the number of project can change (projects added or deleted) and the values of each field can change too.

       

      To load my data, I concatenate my table every week, and differenciate them with the date and the week number.

       

      The next step is to be able to compare two weeks data and show those which has changed.

      First to show in two tables the added projects and deleted projects.

      Secondly to show projects with a value that has changed compared to last week. This comparison has to be done on every columns.

       

      I have no idea of how to do that and hope someone will be able to help me.

        • Re: Comparing data
          Robert Svebeck

          With "Alternate States" you will be able to show two different date or week selections in one single chart, and then also show the differences between them.


          Do you know how Alternate State works?


          Robert

          • Re: Comparing data
            Andrey Khoronenko

            Hi Charlie,

             

            In the attached file ideas on the possible construction of your application. In the table "Change Volume Project" the data of the project parameter at the beginning of the week and the changes for the previous week are shown. The remaining figures should be clear from the contents of the charts. I hope this helps you something.

             

            Regards,

            Andrey

            • Re: Comparing data
              Charlie Audebert

              Thanks to both of you, but it's the wrong location. I am using Qlik Sense and not Qlik View, my mistake, sorry. I move it in the right one.

               

              But no I don't know Alternate State, is it existing in Qlik Sense too ?

               

              Charlie

              • Re: Comparing data
                Charlie Audebert

                Here is an exemple of what I would like.

                 

                I load my data to obtain the table below:

                 

                DateProjectStatusValueDeadline
                08/05/2017001B1000

                31/10/2017

                08/05/2017002C200031/10/2017
                15/05/2017001B100031/12/2017
                15/05/2017002D200031/10/2017
                15/05/2017003A300031/10/2017
                15/05/2017004A50031/12/2017
                22/05/2017001C150031/12/2017
                22/05/2017003A300031/12/2017
                22/05/2017004A30031/12/2017
                22/05/2017005A100031/12/2017

                 

                 

                I want to compare the data between 15/05 and 22/05 and represent:

                 

                • New project
                ProjectStatusValueDeadline
                005A1000

                31/12/2017

                 

                 

                • Canceled project
                ProjectStatusValueDeadline
                002D200031/10/2017

                 

                 

                • Status change
                ProjectStatus
                001C

                 

                • Value change
                ProjectValue
                0011500
                004300

                 

                • Deadline change
                ProjectDeadline
                00331/12/2017

                 

                 

                I want to be able to do that comparison between any week (08/05-15/05 and 08/05-22/05).

                 

                Do you have a solution (either in script or expression)?

                 

                Many thanks in advance.

                 

                Charlie