if you want to embed an aggregation function into another aggregation function (like a count() into a sum()), you'll need to use advanced aggregation (i.e. the aggr() function). Please check the help for the details.
If you could come up with some more details (what are your dimensions), and some sample lines of input date (e.g. in an LOAD .. INLINE [...] style), I would assume someone here should be able to help you with the exact syntax.
thank you, I already tried to use the aggr() function but to no avail. Though I don't know whether I just messed up the syntax...
My dimensions should be Application, Priority (sorry, forgot about it in my previous post) and Severity.
Each Application has incidents with prio 1-4 and each prio has a corresponding severity.
At the moment we use an excel sheet which should be transfered in QlikView. I attached the result in excel. Hope that might helps ( I need the formula for the fields "impact" and "average", whereas "impact" should be calculated as I described in my previous post)