Visual tab

[Stefano2]

Hi all,

please could you tell me what is the script in qlik sense to use the sumifs Excel formula?

so, to obtain A= 2, B=7, C= 5?

Category	Month	Values
A	Jan	0
A	Feb	2
A	March	0
B	Jan	1
B	Feb	1
B	March	5
C	Jan	0
C	Feb	0
C	March	5

[AshutoshBhumkar]

is it possible in qlik sense the move or copy a table created in the visualization area to the data manager ? - NO

or the the data manager can be populed only by external files ? - YES

[Stefano2]

ok , thanks

last question,   If [Values] is a created field through a script why the formula sum ( [Values] ) doesn't work ?

Sum function works only if I sum fields that i've created in visualization using scripts. There is another way to sum that type of fields? 

[AshutoshBhumkar · Accepted solution]

No SUM only should work.

SUM is the an aggregation function which calculates the total of the values given by the expression or field across the aggregated data.

🙂

Thanks,

Ashutosh