topic Re: How to find Total amount charged for given data which is incremental and cannot be bucketed ? in QlikView

How to find Total amount charged for given data which is incremental and cannot be bucketed ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to find Total amount charged for from the given data where CONCLAVE_TYPE = Group

Charge for Conclave is 1200 per day per person attended.

Note : And this data gets new rows in every Six Hours .

Example

For UKAB2 : It is attended by only one person and conclave was for only 1 day , so calculation will be

1200*1*1 = 1200

For UKAB4 : It is attended by three person and conclave was for only 3 days(25,26,27) , so calculation will be

1200*3*3 = 10800

Like wise , my requirement is basically Sum(cHARG

Thanks & Regards

Shekar

sunny_talwar — Fri, 01 Jun 2018 11:25:32 GMT

May be something like this

1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1)

sunny_talwar — Fri, 01 Jun 2018 11:27:45 GMT

Image and sample attached

shekhar_analyti — Fri, 01 Jun 2018 11:31:22 GMT

Sunny Bhai ..Thank for reply ... Actually i wanted an expression for Text Box , which should display total Charge

sunny_talwar — Fri, 01 Jun 2018 11:37:48 GMT

Try this

Sum(Aggr(1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1), CONCLAVE_ID))