topic Match and Max Date in QlikView

Match and Max Date

cbaqir — Wed, 19 Jul 2017 19:38:08 GMT

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.

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!

Re: Match and Max Date

vishsaggi — Wed, 19 Jul 2017 19:48:19 GMT

Is this sheet hidden again? 🙂

Re: Match and Max Date

vishsaggi — Wed, 19 Jul 2017 19:49:48 GMT

Dont worry i got it. Will let you know.

Re: Match and Max Date

cbaqir — Wed, 19 Jul 2017 20:56:48 GMT

dang it!

Re: Match and Max Date

vishsaggi — Wed, 19 Jul 2017 21:01:14 GMT

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.

Re: Match and Max Date

cbaqir — Wed, 19 Jul 2017 21:05:33 GMT

Thanks again!