Select value of max date

kbryndum — Wed, 06 Jun 2012 16:13:40 GMT

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:

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

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

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

topic Select value of max date in QlikView