topic Re: Having Trouble Matching Dates in QlikView https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092698#M940272 <HTML><HEAD></HEAD><BODY><P>Wow, that works perfectly!</P><P></P><P>Why does it work? </P></BODY></HTML> Thu, 28 Jan 2016 20:17:39 GMT timothyj 2016-01-28T20:17:39Z Having Trouble Matching Dates https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092696#M940270 <HTML><HEAD></HEAD><BODY><P>I have a product that changes price periodically. I need to be able to flag the latest price. I have the State, Area and Gender along with implementation date and price. I use a combination of State, Area, and Gender to get a Aggr Key and then use an Aggr function in a calculated dimension to get the Max Date. All this seems to work. All I have to do now is flag where the Imp Date matches the Max Date. I just cannot get this to work. I have tried as dates, numbers and text. I just cannot get dates to match. I have searched and Googled and spent many hours on this. I just cannot figure it out. Any ideas. Attached is a sample qvw.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 28 Jan 2016 14:25:53 GMT https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092696#M940270 timothyj 2016-01-28T14:25:53Z Re: Having Trouble Matching Dates https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092697#M940271 <HTML><HEAD></HEAD><BODY><P>Try this as calculated Match dimension:</P><P></P><P>=Aggr(if(Max(Total&lt;[AGGR KEY]&gt; [Imp Date])=[Imp Date],1,0),[Imp Date], [AGGR KEY])</P></BODY></HTML> Thu, 28 Jan 2016 20:01:52 GMT https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092697#M940271 swuehl 2016-01-28T20:01:52Z Re: Having Trouble Matching Dates https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092698#M940272 <HTML><HEAD></HEAD><BODY><P>Wow, that works perfectly!</P><P></P><P>Why does it work? </P></BODY></HTML> Thu, 28 Jan 2016 20:17:39 GMT https://community.qlik.com/t5/QlikView/Having-Trouble-Matching-Dates/m-p/1092698#M940272 timothyj 2016-01-28T20:17:39Z