Incremental data file

[#1]

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 😎

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

Anyone could help.

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

[#2]

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)

[#3 · Accepted solution]

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