Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
Gysbert_Wassenaar

sub Sum

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

end sub


talk is cheap, supply exceeds demand
Not applicable
Author

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

Jg