topic Sum values of unique rows in QlikView

Sum values of unique rows

arsallee3 — Fri, 20 Nov 2015 05:18:17 GMT

Working on problem to calculate the sum of values for the maximum created on date for each unique ID

Result looking for is sum of the highlighted ones above, total projection would equal 4560.

Not sure if need to find this in a load or if I can get it from expression.

Appreciate any assistance.

marcus_sommer — Fri, 20 Nov 2015 09:06:43 GMT

Try something like this: sum(aggr(FirstSortedValue([Projected Value], -[Created on]), ID))

- Marcus

sunny_talwar — Fri, 20 Nov 2015 09:09:02 GMT

May be use an expression like this:

=FirstSortedValue([Project Value], -Floor([Created on]))

Dimension = ID and Projected Month

arsallee3 — Fri, 20 Nov 2015 15:47:56 GMT

Awesome, so many functions that need to learn!

Loving the program and the community and look forward to being able to assist others myself in the future!