2 Replies Latest reply: Aug 29, 2012 6:24 AM by Sebastian Blum RSS

    Incremental data file

      Hi all

       

      Try to develop a time series line chart showing 2 lines over Mth as below:-

      sum(1.1 to 3.2)/sum(1.1 to 8)

      sum(4.1 to 8)/sum(1.1 to 8)

       

      Anyone could help.

       

      Mth1.11.22.12.23.13.24.14.25678
      Jul-113120152813169362226
      Aug-1132181527131413352426
      Sep-1132201531151610362103
      Oct-1144181830161710352203
      Nov-1143141529151310332002
      Dec-1133151228161310331302
      Jan-123317172920138213302
      Feb-123117192720139153402
      Mar-123116182620137163402
      Apr-123116192521138163502
      May-123218192120137133702
      Jun-122217182119127142800
      Jul-122217192119127132350
        • Re: Incremental data file
          Wojciech Parzyszek

          Hi

           

          you can use this code:

           

          robodata:

          LOAD * INLINE [

              Mth, 1.1, 1.2, 2.1, 2.2, 3.1, 3.2, 4.1, 4.2, 5, 6, 7, 8

              Jul-11, 3, 1, 20, 15, 28, 13, 16, 9, 36, 22, 2, 6

              Aug-11, 3, 2, 18, 15, 27, 13, 14, 13, 35, 24, 2, 6

              Sep-11, 3, 2, 20, 15, 31, 15, 16, 10, 36, 21, 0, 3

              Oct-11, 4, 4, 18, 18, 30, 16, 17, 10, 35, 22, 0, 3

              Nov-11, 4, 3, 14, 15, 29, 15, 13, 10, 33, 20, 0, 2

              Dec-11, 3, 3, 15, 12, 28, 16, 13, 10, 33, 13, 0, 2

              Jan-12, 3, 3, 17, 17, 29, 20, 13, 8, 21, 33, 0, 2

              Feb-12, 3, 1, 17, 19, 27, 20, 13, 9, 15, 34, 0, 2

              Mar-12, 3, 1, 16, 18, 26, 20, 13, 7, 16, 34, 0, 2

              Apr-12, 3, 1, 16, 19, 25, 21, 13, 8, 16, 35, 0, 2

              May-12, 3, 2, 18, 19, 21, 20, 13, 7, 13, 37, 0, 2

              Jun-12, 2, 2, 17, 18, 21, 19, 12, 7, 14, 28, 0, 0

              Jul-12, 2, 2, 17, 19, 21, 19, 12, 7, 13, 23, 5, 0

          ];

           

          CrossTable(range, value)

          LOAD Mth,

               [1.1],

               [1.2],

               [2.1],

               [2.2],

               [3.1],

               [3.2],

               [4.1],

               [4.2],

               [5],

               [6],

               [7],

               [8]

          resident robodata;

           

          drop table robodata;

           

           

           

           

          and set the expressions like :

          =sum({$<range={'1.1','1.2','2.1','2.2','3.1','3.2'}>}value)

          =sum({$<range={'4.1','4.2','5','6','7','8'}>}value)

          • Re: Incremental data file
            Sebastian Blum

            Hi,

             

            If I got you right, the attached application should be the solution. Please note that I replaced the headlines 1.1, 1.2 etc. by F1.1, F1.2 etc., in order not to get in trouble with settings for comma, stops and other characters. I read them from an Excel file and transformed the crosstable into a list which is easy to handle in QlikView.

             

            The chart is build by using set expressions.

             

            Is this what you needed?

             

            Regards,

            sebablum