Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
amarnath4bi
Contributor
Contributor

How to get total field with auto increment

Hi,

I have a source

Product Price
A100
B250
C150

But i want to display with extra column like this

ProductPriceTotal
A100100
B250350
C150500

How can I get total field by auto increment.

5 Replies
ychaitanya
Creator III
Creator III

Hey Amar

Use this

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

Digvijay_Singh
Master III
Master III

Looks like duplicate thread!!

MarcoWedel

krishna_2644
Specialist III
Specialist III

Check this out.1.PNG

shiveshsingh
Master
Master

Use this as expression

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