aggregated data counting

warrentk80 — Mon, 03 Sep 2018 08:11:21 GMT

Goodmorning everyone

I have a table containing names, and the final accounts divided month by month with information whether they have been reviewed or not.
I would need to count the revised accounts as a resource and make the relationship between those reviewed / adjusted and the totals.

attached excel file of example with base date and that and the expressions that I would like to have (columns in yellow)

for the counting of the updated results I tried to use the expression aggr (sum (#Is Adjustment), Resource Full Name) but I extract the lottery numbers 🙂

attached example

thank you all

Andrew

Re: aggregated data counting

Or — Mon, 03 Sep 2018 08:22:47 GMT

This doesn't look like it requires aggr() - a simple sum() will do:

sum(total <[Resource Full Name]> [#Is Adjustment])

(and for the second part):

/count(total <[Resource Full Name]> [#Is Adjustment])

topic Re: aggregated data counting in QlikView

aggregated data counting

Re: aggregated data counting