Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I used this expression in qlikview and it's working fine.
total revenue:
sum(aggr(((Count(AppointmentID) * sum(VisitAmount))), [Doctor]))
But it doesn't working in qlik sense !!
I need help to calculate the total revenue.
There is no difference between qlikview and qlik sense related to these kind of expressions - therefore something else must be different - check the syntax (too much parenthesis aren't helpful - it's rather the opposite) and that there no typos and also that fields are case-sensitive.
- Marcus
sum(aggr((Count(AppointmentID) * sum(VisitAmount)), [Doctor]))
should work (have moved your brackets around a little)