Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kbryndum
Partner - Contributor
Partner - Contributor

Select value of max date

Hi,

I need some help...

I have generated a table with two (or more) dimensions and an expression. The one of the dimensions is a time dimension.

The table looks like this:

Global   Item IdYear_Month2Year_MonthRunningSum
SW1293201203Mar-12149
SW1293201204Apr-12147
SW1293201205May-12201
SW1294201203Mar-1227
SW1294201204Apr-1275
SW1294201205May-1245
SW1297201203Mar-1212
SW1325201202Feb-12250
SW1325201203Mar-12102
SW1326201202Feb-12100
SW1326201203Mar-1225

If the value selected is May-12, then I would like the result to be like this:

Global   Item IdYear_Month2Year_MonthValue
SW1293201205May-12201
SW1294201205May-1245
SW1297201203Mar-1212
SW1325201203Mar-12102
SW1326201203Mar-1225

If the value selected is Apr-12, then I would like the result to be like this:

Global   Item IdYear_Month2Year_MonthValue
SW1293201204Apr-12147
SW1294201204Apr-1275
SW1297201203Mar-1212
SW1325201203Mar-12102
SW1326201203Mar-1225

I have tried to work with Set Modifiers with implicit field value definitions, like this (there could be non-associated time values):


Sum({$<Year_Month2 = {$(=Max( {$<Year_Month2 = P({1} Year_Month2)>} Year_Month2 ) )}>}
RunningSum)

But it doesn't work, as it only selects lines where Year_Month2 is equal the max possible time value.

Can anyone help? Any help is much appreciated!

Thanks

Kim

0 Replies