topic Re: Top 15 DATETIMES in QlikView https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142418#M901699 <HTML><HEAD></HEAD><BODY><P>May be like this for your calculated dimension:</P><P><STRONG>If(Max(TOTAL DATETIMES, 15) &lt;= DATETIMES, DATETIMES)</STRONG></P></BODY></HTML> Tue, 12 Jul 2016 20:08:08 GMT sunny_talwar 2016-07-12T20:08:08Z Top 15 DATETIMES https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142417#M901697 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">My date field has a time stamp.</SPAN>How can I create a calculated dimension which displays only Top or Recent 15 date times. Dimension limits didn't work when i select show only first 15 values.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142417#M901697 2020-11-25T16:16:04Z Re: Top 15 DATETIMES https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142418#M901699 <HTML><HEAD></HEAD><BODY><P>May be like this for your calculated dimension:</P><P><STRONG>If(Max(TOTAL DATETIMES, 15) &lt;= DATETIMES, DATETIMES)</STRONG></P></BODY></HTML> Tue, 12 Jul 2016 20:08:08 GMT https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142418#M901699 sunny_talwar 2016-07-12T20:08:08Z Re: Top 15 DATETIMES https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142419#M901700 <HTML><HEAD></HEAD><BODY><P>Great,it worked</P></BODY></HTML> Tue, 12 Jul 2016 20:39:08 GMT https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142419#M901700 2016-07-12T20:39:08Z Re: Top 15 DATETIMES https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142420#M901701 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌:If I use that expression as calculated dimension,I am not able to select a specific datetime .If I select any datetime field then the straight table gives zero results.Is there any way to over come this??<IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131169_1.PNG" style="height: auto;" /></P><P><IMG alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/131170_2.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 13 Jul 2016 16:36:02 GMT https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142420#M901701 2016-07-13T16:36:02Z Re: Top 15 DATETIMES https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142421#M901702 <HTML><HEAD></HEAD><BODY><P>How about if you try this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">If(Max(TOTAL <SPAN style="color: #ff0000;">{&lt;</SPAN><STRONG style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DATETIMES = {"&lt;=$(=Max(</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;">DA</SPAN><SPAN style="color: #ff0000;">TETIMES</SPAN></STRONG></STRONG><STRONG style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">))"}</STRONG><SPAN style="color: #ff0000;">&gt;}</SPAN> DATETIMES, 15) &lt;= DATETIMES, DATETIMES)</STRONG></P></BODY></HTML> Wed, 13 Jul 2016 16:43:02 GMT https://community.qlik.com/t5/QlikView/Top-15-DATETIMES/m-p/1142421#M901702 sunny_talwar 2016-07-13T16:43:02Z