Incremental sum of fields

Anonymous — Thu, 28 Feb 2013 14:20:25 GMT

Hello!

I'm trying to make an incremental sum of fields.

Using an import table:

Test1	Test2	Test3	Test4	Test5	Test6
1	1	1	1	1	6
2	2	2	2	2	1
3	3	3	3	3	2
4	4	4	4	4	3
5	5	5	5	5	4
6	6	6	6	6	5
7	7	7	7	7	6
8	8	8	8	8	7
9	9	9	9	9	8

And one table with fields like that:

Test1	Test2	Test3	Test4	Test5	Test6	Expression1	Expression2	Expression3	Expression4	Expression5
1	1	1	1	1	6	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
2	2	2	2	2	1	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
3	3	3	3	3	2	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
4	4	4	4	4	3	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
5	5	5	5	5	4	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
6	6	6	6	6	5	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
7	7	7	7	7	6	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
8	8	8	8	8	7	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6
9	9	9	9	9	8	Test1+Test2	Test1+Test2+Test3	Test1+Test2+Test3+Test4	Test1+Test2+Test3+Test4+Test5	Test1+Test2+Test3+Test4+Test5+Test6

But instead use the formula, I want to use Variables like:

Test1	Test2	Test3	Test4	Test5	Test6	Expression1	Expression2	Expression3	Expression4	Expression5
1	1	1	1	1	6	Variable1	Variable2	Variable3	Variable4	Variable5
2	2	2	2	2	1	Variable1	Variable2	Variable3	Variable4	Variable5
3	3	3	3	3	2	Variable1	Variable2	Variable3	Variable4	Variable5
4	4	4	4	4	3	Variable1	Variable2	Variable3	Variable4	Variable5
5	5	5	5	5	4	Variable1	Variable2	Variable3	Variable4	Variable5
6	6	6	6	6	5	Variable1	Variable2	Variable3	Variable4	Variable5
7	7	7	7	7	6	Variable1	Variable2	Variable3	Variable4	Variable5
8	8	8	8	8	7	Variable1	Variable2	Variable3	Variable4	Variable5
9	9	9	9	9	8	Variable1	Variable2	Variable3	Variable4	Variable5

Where:

Variable1 = Test1+Test2

...

Variable5 = Test1+Test2+Test3+Test4+Test5+Test6

But is not working.

Can anyone help me?

Thanks

Re: Incremental sum of fields

Gysbert_Wassenaar — Thu, 28 Feb 2013 14:40:28 GMT

You need to remove the = from the expressions in the variables (so they are evaluated in the chart and not beforehand where the Teste fields don't have values yet) and dollar-expand the variables in the expressions in the straight table. See attached qvw.

Re: Incremental sum of fields

Anonymous — Thu, 28 Feb 2013 17:31:43 GMT

Hello Gysbert,

Thank You so Much!

I have tested without "=" before but didn't work because the way that I was calling the variable was wrong!

Now is perfect!

topic Re: Incremental sum of fields in QlikView

Incremental sum of fields

Re: Incremental sum of fields

Re: Incremental sum of fields