topic Re: Last date as dimension in QlikView https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372313#M516321 <HTML><HEAD></HEAD><BODY><P>Thank you very much, it works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Fri, 05 May 2017 13:18:13 GMT patrou38 2017-05-05T13:18:13Z Last date as dimension https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372310#M516317 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt;">Hello, </SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt;">I would like to put as dimension a Date corresponding to the last one (Max(Date(CutOffDate))</SPAN></P><P><SPAN style="font-size: 14pt;">but without success. </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">I tried this expression below, but something is probably missing <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </SPAN></P><P><SPAN style="font-size: 12pt;">=<SPAN style="color: #0000ff;">if</SPAN>(<SPAN style="color: #0000ff;">date</SPAN>(<SPAN style="color: #800000;">CutOffDate</SPAN>)= <SPAN style="color: #0000ff;">max</SPAN>(<SPAN style="color: #0000ff;">date</SPAN>(<SPAN style="color: #800000;">CutOffDate</SPAN>)), <SPAN style="color: #0000ff;">date</SPAN>(<SPAN style="color: #800000;">CutOffDate</SPAN>) </SPAN></P><P></P><P><SPAN style="font-size: 12pt;"><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/162313_Capture.JPG" style="width: 620px; height: 233px;" /></SPAN></P><P><SPAN style="font-size: 12pt;">Thank you for you help. </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Patrick</SPAN></P></BODY></HTML> Fri, 05 May 2017 12:13:33 GMT https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372310#M516317 patrou38 2017-05-05T12:13:33Z Re: Last date as dimension https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372311#M516319 <HTML><HEAD></HEAD><BODY><P>try:</P><P>IF(CutOffDate = AGGR(MAX(CutOffDate), CutOffDate), DATE(CutOffDate))</P><P></P><P>Peter</P></BODY></HTML> Fri, 05 May 2017 12:24:01 GMT https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372311#M516319 prieper 2017-05-05T12:24:01Z Re: Last date as dimension https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372312#M516320 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: arial, helvetica, sans-serif;">=<STRONG style="color: #0000ff;">Aggr</STRONG>(</SPAN><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><SPAN style="color: #0000ff;">if</SPAN><SPAN style="color: #3d3d3d;">(Date(</SPAN><SPAN style="color: #800000;">CutOffDate)</SPAN><SPAN style="color: #3d3d3d;">= Date(</SPAN><SPAN style="color: #0000ff;">Max</SPAN><SPAN style="color: #3d3d3d;">( <SPAN style="color: #0000ff;">total </SPAN></SPAN><SPAN style="color: #800000;">CutOffDate</SPAN><SPAN style="color: #3d3d3d;">)), </SPAN><SPAN style="color: #0000ff;">date</SPAN><SPAN style="color: #3d3d3d;">(</SPAN><SPAN style="color: #800000;">CutOffDate</SPAN></SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;"><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt; font-family: arial, helvetica, sans-serif;">CutOffDate)</SPAN></SPAN></P></BODY></HTML> Fri, 05 May 2017 12:24:56 GMT https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372312#M516320 tresB 2017-05-05T12:24:56Z Re: Last date as dimension https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372313#M516321 <HTML><HEAD></HEAD><BODY><P>Thank you very much, it works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Fri, 05 May 2017 13:18:13 GMT https://community.qlik.com/t5/QlikView/Last-date-as-dimension/m-p/1372313#M516321 patrou38 2017-05-05T13:18:13Z