Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kbryndum
New 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

Community Browser