topic Re: How to calculate Bill type summation? in QlikView

How to calculate Bill type summation?

Thu, 03 Apr 2014 08:31:10 GMT

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

Re: How to calculate Bill type summation?

alexandros17 — Thu, 03 Apr 2014 08:35:54 GMT

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?

Re: How to calculate Bill type summation?

rohit214 — Thu, 03 Apr 2014 09:00:41 GMT

can you please share the sample data

thanks

rohit

Re: How to calculate Bill type summation?

tresB — Thu, 03 Apr 2014 09:10:21 GMT

For Result column, try expression like:

Sum( Total <Billtype> Value)

Assuming you are using straight table.

Re: Re: How to calculate Bill type summation?

Thu, 03 Apr 2014 09:13:29 GMT

you can take below inline table for sample data.

load * inline[

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.

Re: Re: How to calculate Bill type summation?

Thu, 03 Apr 2014 09:43:58 GMT

Thanks yar it working fine but little change only.

sum(Total<Billtype,Date>Value).

Thank u very much it helped alot.

Thanks,

Ashok.

Re: How to calculate Bill type summation?

Thu, 03 Apr 2014 09:49:01 GMT

Hi,

Please find the attached QVW.

The end result of the chart is

Re: How to calculate Bill type summation?

arjunkrishnan — Thu, 03 Apr 2014 10:04:20 GMT

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

Re: How to calculate Bill type summation?

Tue, 15 Apr 2014 06:42:24 GMT

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

sum({1<Monthname={'$(=monthname(admonths(max(date),-1)))'},Billtype>}Value)

but it gives overall total not bill type wise.

Thanks,

Ashok.