topic Max Date in Expression in QlikView

Max Date in Expression

Anonymous — Tue, 20 Sep 2016 12:32:47 GMT

I am trying to only sum the max date in my expression, here is what I tried so far.

=Sum (if(SNAPSHOT_CCYYMM = 'Max SNAPSHOT_CCYYMM' and CLAIM_STATE= 'Open',1,0))

swuehl — Tue, 20 Sep 2016 17:21:01 GMT

Maybe

=Sum (if(SNAPSHOT_CCYYMM = Max(TOTAL SNAPSHOT_CCYYMM') and CLAIM_STATE= 'Open',1,0))

=Sum (if(SNAPSHOT_CCYYMM = $(=Max( SNAPSHOT_CCYYMM')) and CLAIM_STATE= 'Open',1,0))

Anonymous — Tue, 20 Sep 2016 18:08:54 GMT

Thanks Steve the following one seems to work...

=Sum (if(SNAPSHOT_CCYYMM = $(=Max( SNAPSHOT_CCYYMM')) and CLAIM_STATE= 'Open',1,0))