Discussion board where members can get started with QlikView.
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 .
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
Sum(Aggr(1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1), CONCLAVE_ID))
View solution in original post
May be something like this
1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1)
Image and sample attached
Sunny Bhai ..Thank for reply ... Actually i wanted an expression for Text Box , which should display total Charge