Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Match and Max Date

I only want to show the row with the most recent start date per DEFECT_ID... in this case 5/3/17 with a total of 77 days.

7-19-2017 12-35-59 PM.jpg

I need to adjust this dimension to show only the MAX GPQ2_START_DATE when CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0:

=date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null()) , 'MM/DD/YYYY')

Can anyone help? TIA!

Tags (2)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Match and Max Date

Try this?

= Aggr(IF(Rank(Date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null())), 0) = 1, GPQ2_START_DATE), DEFECT_ID, GPQ2_START_DATE)

Then Check Supress When Value is Null for that calculated dimension.

5 Replies
vishsaggi
Esteemed Contributor III

Re: Match and Max Date

Is this sheet hidden again? :-)

vishsaggi
Esteemed Contributor III

Re: Match and Max Date

Dont worry i got it. Will let you know.

cbaqirdhds
Contributor II

Re: Match and Max Date

dang it!

vishsaggi
Esteemed Contributor III

Re: Match and Max Date

Try this?

= Aggr(IF(Rank(Date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null())), 0) = 1, GPQ2_START_DATE), DEFECT_ID, GPQ2_START_DATE)

Then Check Supress When Value is Null for that calculated dimension.

cbaqirdhds
Contributor II

Re: Match and Max Date

Thanks again!

Community Browser