topic Re: Incremental data file in QlikView

Incremental data file

Wed, 29 Aug 2012 09:20:22 GMT

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

Re: Incremental data file

Wed, 29 Aug 2012 09:56:56 GMT

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

Wed, 29 Aug 2012 10:24:20 GMT

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