Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

olivierbuchy
Contributor

Get expression for latest date

ex. Loaded table


Week, value

week 1, 2

week 1, 3

week 1, 1

week 2, 1

week 2, 3

week 3, 1

week 3, 2

I want to get : sum(value) for most recent week (i.e. "week 3"); I suspect a combination of aggr() and firstsortedvalue() should do the trick, but I can't nail it down.

Thanks for your help.

1 Solution

Accepted Solutions
MVP
MVP

Re: Get expression for latest date

=Sum({<Week={"$(=MaxString({1}Week))"}>} Value)

2 Replies
MVP
MVP

Re: Get expression for latest date

=Sum({<Week={"$(=MaxString({1}Week))"}>} Value)

olivierbuchy
Contributor

Re: Get expression for latest date

Thanks, Set Analysis was the answer.

Community Browser