topic Set analysis. Max date in QlikView

Set analysis. Max date

MindaugasBacius — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am stuck here with a quite simple task.

I have data like:

Expected output:

2015-01 2

2015-02 4

2015-03 11

Sum of Data in the max date per Year month. This have to be dynamic as here will appear other Calendar fields like [Year week], [Year quarter].

See the attachment.

Thank you for helping me out.

MK_QSL — Mon, 10 Apr 2017 06:02:25 GMT

=FirstSortedValue(Distinct Aggr(SUM(Data),Date),-Date)

rahulpawarb — Mon, 10 Apr 2017 06:11:53 GMT

Hello Mindaugas,

You can make use of Resident Load as below:

LOAD [Year month],

MAX(Data) AS Data

Resident BaseTable

Group By [Year month];

Regards!

Rahul