# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Not applicable

## How to calculate Bill type summation?

Hi ,

I have data like below

 Date Billtype Queue LOB Value 4/1/2014 UB DE A 10 4/1/2014 B 20 4/1/2014 VER C 30 4/1/2014 HCFA DE A 1 4/1/2014 B 2 4/1/2014 C 3

i need result like below

 Dae Billtype Queue LOB Value Result 4/1/2014 UB DE A 10 60 4/1/2014 B 20 60 4/1/2014 VER C 30 60 4/1/2014 HCFA DE A 1 6 4/1/2014 B 2 6 4/1/2014 C 3 6
1 Solution

Accepted Solutions
Not applicable

## Re: Re: How to calculate Bill type summation?

Thanks yar it working fine but little change only.

sum(Total<Billtype,Date>Value).

Thank u very much it helped alot.

Thanks,

Ashok.

8 Replies
MVP

## Re: How to calculate Bill type summation?

But what is the logic to sum values to obtain result?

Data is the same and other fields are not present in all records.

How to aggregate Result?

Contributor III

## Re: How to calculate Bill type summation?

can you please share the sample data

thanks

rohit

MVP

## Re: How to calculate Bill type summation?

For Result column, try expression like:

Sum( Total <Billtype> Value)

Assuming you are using straight table.

Not applicable

## Re: Re: How to calculate Bill type summation?

you can take below inline table for sample data.

 Date Billtype Queue LOB Value 4/1/2014 UB DE A 10 4/1/2014 B 20 4/1/2014 VER C 30 4/1/2014 HCFA DE A 1 4/1/2014 B 2 4/1/2014 C 3

];

otherwise you can below attachment.

Thanks,

Ashok.

Not applicable

## Re: Re: How to calculate Bill type summation?

Thanks yar it working fine but little change only.

sum(Total<Billtype,Date>Value).

Thank u very much it helped alot.

Thanks,

Ashok.

Not applicable

## Re: How to calculate Bill type summation?

Hi,

The end result of the chart is

Contributor II

## Re: How to calculate Bill type summation?

Use This Expression Very Helpful For U

(=aggr(NODISTINCT Sum(Value),Billtype))

And

Lets Pls Find The Attachment It's Very Much Helpful For U..!

Regards By

ArjunKrish

Not applicable

## Re: How to calculate Bill type summation?

Hi Tresesco,

I have one more question ,i need same result format as like above but i need previous month bill type total.

i am using below expression