Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to add values to total

Hi,

I need help,

How can I add values to the total field as shown below.

ProductValueTotal
A100100
B250350
C50400
D50450

In my source I have only Product and value fields . How can I calculate Total Field.

5 Replies
ychaitanya
Creator III
Creator III

you can use like this :

above(sum(value),0,rowno()-1)

Thanks

ychaitanya
Creator III
Creator III

Use this

aggr( rangesum(above( sum(Price), 0, rowno() )), Price)

Digvijay_Singh

May be this for Total measure -

Rangesum(Above(Sum(Value),0,Rowno()))

shiveshsingh
Master
Master

like this

RangeSum(above(sum(Price),0,RowNo()))