Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to calculate Bill type summation?

Hi ,

I have data like below

DateBilltypeQueueLOBValue
4/1/2014UBDEA10
4/1/2014B20
4/1/2014VERC30
4/1/2014HCFADEA1
4/1/2014B2
4/1/2014C3

i need result like below

DaeBilltypeQueueLOBValueResult
4/1/2014UBDEA1060
4/1/2014B2060
4/1/2014VERC3060
4/1/2014HCFADEA16
4/1/2014B26
4/1/2014C36
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

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?

rohit214
Contributor III

Re: How to calculate Bill type summation?

can you please share the sample data

thanks

rohit


MVP
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.

load * inline[

DateBilltypeQueueLOBValue
4/1/2014UBDEA10
4/1/2014B20
4/1/2014VERC30
4/1/2014HCFADEA1
4/1/2014B2
4/1/2014C3

];

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,

Please find the attached QVW.

The end result of the chart is

arjunkrishnan
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

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

but it gives overall total not bill type wise.

Thanks,

Ashok.