topic Re: QlikView Expression for maximum reporting month in QlikView

QlikView Expression for maximum reporting month

mohdhaniff — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: QlikView Expression for maximum reporting month

prma7799 — Mon, 17 Jul 2017 05:19:55 GMT

Your expression looks like good ..

Please check your [Reporting Month] format

Or please share some sample app.

Re: QlikView Expression for maximum reporting month

mohdhaniff — Mon, 17 Jul 2017 05:37:47 GMT

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))))