topic Max of Date in QlikView https://community.qlik.com/t5/QlikView/Max-of-Date/m-p/1290854#M622319 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I want to write a formula for max of a Date which if i change my dimension and filter for example last year it always shows the max.</P><P>Should i use set analysis for this? How?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 15 Mar 2017 08:23:21 GMT 2017-03-15T08:23:21Z Max of Date https://community.qlik.com/t5/QlikView/Max-of-Date/m-p/1290854#M622319 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P>I want to write a formula for max of a Date which if i change my dimension and filter for example last year it always shows the max.</P><P>Should i use set analysis for this? How?</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 15 Mar 2017 08:23:21 GMT https://community.qlik.com/t5/QlikView/Max-of-Date/m-p/1290854#M622319 2017-03-15T08:23:21Z Re: Max of Date https://community.qlik.com/t5/QlikView/Max-of-Date/m-p/1290855#M622320 <HTML><HEAD></HEAD><BODY><P>Yes, you can do this using set analysis</P><P></P><P><STRONG>Max({1} Date)</STRONG></P></BODY></HTML> Wed, 15 Mar 2017 15:58:15 GMT https://community.qlik.com/t5/QlikView/Max-of-Date/m-p/1290855#M622320 sunny_talwar 2017-03-15T15:58:15Z