Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

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 .


per day.png

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

1 Solution

Accepted Solutions
Highlighted

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

Try this

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

Capture.PNG

View solution in original post

4 Replies
Highlighted

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

May be something like this

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

Highlighted

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

Image and sample attached

Capture.PNG

Highlighted
Specialist
Specialist

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

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

Highlighted

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

Try this

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

Capture.PNG

View solution in original post