Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

QlikView Expression for maximum reporting month

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.

1 Solution

Accepted Solutions
Highlighted
Contributor

Re: QlikView Expression for maximum reporting month

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

View solution in original post

2 Replies
Highlighted
Honored Contributor III

Re: QlikView Expression for maximum reporting month

Your expression looks like good ..

Please check your [Reporting Month] format

Or please share some sample app. 

Highlighted
Contributor

Re: QlikView Expression for maximum reporting month

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

View solution in original post