topic min selected date on dimension in QlikView https://community.qlik.com/t5/QlikView/min-selected-date-on-dimension/m-p/150805#M28766 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I'm trying to apply logic in an if statement on a pivot chart dimension where i want to compare the min selected date to each of the rows in the chart.</P><P>I had been using aggr(min(date), group).</P><P>e.g. if i select aug, sep, oct in my date range im trying to get a statement together to compare august with august, september with august and october with august.<BR />what is happening is it is comparing august with august, september with september and october with october.</P><P>Any ideas?</P><P>Thanks,<BR />Kevin.</P></BODY></HTML> Fri, 31 Jul 2009 18:48:23 GMT 2009-07-31T18:48:23Z min selected date on dimension https://community.qlik.com/t5/QlikView/min-selected-date-on-dimension/m-p/150805#M28766 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I'm trying to apply logic in an if statement on a pivot chart dimension where i want to compare the min selected date to each of the rows in the chart.</P><P>I had been using aggr(min(date), group).</P><P>e.g. if i select aug, sep, oct in my date range im trying to get a statement together to compare august with august, september with august and october with august.<BR />what is happening is it is comparing august with august, september with september and october with october.</P><P>Any ideas?</P><P>Thanks,<BR />Kevin.</P></BODY></HTML> Fri, 31 Jul 2009 18:48:23 GMT https://community.qlik.com/t5/QlikView/min-selected-date-on-dimension/m-p/150805#M28766 2009-07-31T18:48:23Z