topic Re: How to sum ALL values from a field, using MACRO? in QlikView

How to sum ALL values from a field, using MACRO?

Mon, 14 Jan 2013 17:39:21 GMT

Hello,

I have a table like that:

Data:

LOAD * INLINE [

rank, Value, teste

1, 900

2, 810

3, 800

4, 780

5, 720

6, 620

7, 500

8, 500

9, 320

10, 300

11, 220

12, 200

13, 125

14, 60

15, 40

16, 10

];

I have to sum Value with Macro.

Thank you

Gysbert_Wassenaar — Mon, 14 Jan 2013 18:18:45 GMT

sub Sum

msgbox(activedocument.Evaluate("sum(Value)"))

end sub

Mon, 14 Jan 2013 21:02:02 GMT

Thank you Gysbert,

So, then more 2 question:

1. Can i use set analysis on it?

2. when i apply a filter before this command, i cant view the correr result. Could you send me your email? I would like to send you my application.

Thank you again