Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Calculate Previous Record

Thanks all.

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

4 Replies
saumyashah90
Valued Contributor

Re: Calculate Previous Record

Put it in Pivot table

Re: Calculate Previous Record

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
Honored Contributor III

Re: Calculate Previous Record

What do you mean by previous in your title .

plz explain .

Not applicable

Re: Calculate Previous Record

Thanks all.

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

Community Browser