Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Total column.

Hello everyone!

Do you have any way to total the column "Acumulado".

ProdutoAtualAnteriorAcumuladoAcumulado - correct
684--5273
A11-1111
B76118787
C10769797
D2410121121
E8224203203
F3882241241
G838249249
H748323323
I9574418418
J4195459459
K8241541541
L4182582582
M3841620620
N1738637637
O4717684684
8 Replies
Nicole-Smith

I've attached the fixed .qvw.

What I did:

Capture.PNG

Anonymous
Not applicable
Author

Have to be in the expression.

Nicole-Smith

I'm not sure what you want.  What I did gives the results that you wanted in your first post...

Capture.PNG

Anonymous
Not applicable
Author

I need the sum of the expression SUM(Acumulado).

Nicole-Smith

You need it where?  It does exist on the table (if you do what I have in my above post) if that's where you want it...

Capture.PNG

Anonymous
Not applicable
Author

I really need the sum in the expression.

Not applicable
Author

friend, a question like you did that colummna earlier, if I can pass the code, please

Anonymous
Not applicable
Author

This expression is not solved my case, but it works.

 

if

(Dimensionality()=0,noofrows()*((Count(distinct DATA)+1)/2), RowNo(total

))