Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

aggregated data counting

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

1 Reply
Or
MVP
MVP

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])