QlikView Expression for maximum reporting month

[mohdhaniff]

Hi,

Currently, I am using below expression to view my reports:

Count(

if([Col Segment]='N',if(Status<>'I',

if(len(trim([CRDE BizRules]))>0,AANUM))))

Now, I wish to add more filter to get my reports displayed items that matched with maximum date (refer to blue color) as below. However, I am getting null result:

Count({$<[Reporting Month]={'$(=max([Reporting Month]))'}>}

if([Col Segment]='N',if(Status<>'I',

if(len(trim([CRDE BizRules]))>0,AANUM))))

Please help me to input a correct expression for maximum Reporting Month.

Regards.

[prma7799]

Your expression looks like good ..

Please check your [Reporting Month] format

Or please share some sample app. 

[mohdhaniff · Accepted solution]

Thanks, I got it:

Count({$<[Reporting Month]={"$(=Date(max([Reporting Month]),'DD-MMM-YYYY'))"}>}

if([Col Segment]='N',if(Status<>'I',

if(len(trim([CRDE BizRules]))>0,AANUM))))