Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Previous Record

Hi,

We have following data

CustomerMeterNoMonthReading
Customer AMeter1Jan-131521
Customer AMeter1Feb-131820
Customer AMeter1Mar-131989
Customer AMeter2Jan-1332164
Customer AMeter2Feb-1332456
CustomerBMeter1Jan-134454
CustomerBMeter1Feb-134485
CustomerBMeter1Mar-134565

we want to calculate total consumed units of the month Customer and meter wise

Any help..?

1 Solution

Accepted Solutions
Not applicable
Author

Thanks all.

But i solve this to my self by Previous function in script.

View solution in original post

4 Replies
saumyashah90
Specialist
Specialist

Put it in Pivot table

Gysbert_Wassenaar

No idea what you actually want, but one of these probably gives the result you want.

Total per customer: sum(total <Customer> Reading)

Total per month: sum(total <Month> Reading)

Total per meter: sum(total <MeterNo> Reading)

Total per customer per meter: sum(total <Customer, MeterNo> Reading)

Total per customer per month: sum(total <Customer, Month> Reading)

Total per meter per month: sum(total <MeterNo,Month> Reading)

See attached example


talk is cheap, supply exceeds demand
sujeetsingh
Master III
Master III

What do you mean by previous in your title .

plz explain .

Not applicable
Author

Thanks all.

But i solve this to my self by Previous function in script.