Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expression in Qlik Sense

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.

2 Replies

Re: Expression in Qlik Sense

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

Not applicable

Re: Expression in Qlik Sense

sum(aggr((Count(AppointmentID) * sum(VisitAmount)), [Doctor]))

should work (have moved your brackets around a little)