Max Value (Date Field)

hkg_qlik — Tue, 31 Jul 2012 14:13:49 GMT

Hi,

I have a straight table with two date fields as dimensions:

1. Date Processed

2. Submitted to Acct.

Now I want for all Date Processed only the max of (Sumbitted to Acct) ?

Thanks,

Re: Max Value (Date Field)

matt_crowther — Tue, 31 Jul 2012 15:20:03 GMT

If I understnad you correctly give this a try:

Your 'Submitted to Acct' should be an expression with: '=max(total <[Date Processed]> [Submitted to Acct.])'

You can also create a 'Max Submitted to Acct.' field in the script by doing a resident Group By Left Join to the original table.

Left Join (TableA)

Load [Date Processed],

max([Submitted to Acct.] as Max_Sub_to_Acct

Resident TableA;

Hope that helps,

Matt - Visual Analytics Ltd

@QlikviewBI