Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mohdhaniff
Creator
Creator

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
mohdhaniff
Creator
Creator
Author

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
prma7799
Master III
Master III

Your expression looks like good ..

Please check your [Reporting Month] format

Or please share some sample app. 

mohdhaniff
Creator
Creator
Author

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