topic Re: How to display the biggest of the numbers in QlikView https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050325#M352663 <HTML><HEAD></HEAD><BODY><P>Thank you Edagr,but this gives an error which says error in calculated dimension.</P></BODY></HTML> Sat, 23 Jan 2016 02:10:53 GMT 2016-01-23T02:10:53Z How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050317#M352655 <HTML><HEAD></HEAD><BODY><P>If I have 3 numbers</P><P>ID Num</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90. </P><P></P><P>Here for ID 1 i only want to display 60 which is the largest among 10 and 60.How do I do that ?</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 21 Jan 2016 20:18:05 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050317#M352655 2016-01-21T20:18:05Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050318#M352656 <HTML><HEAD></HEAD><BODY><P>May be like this in straight table:</P><P></P><P>Dimension: <STRONG>ID</STRONG></P><P>Expression: <STRONG>Max(Num)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112269_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Thu, 21 Jan 2016 20:19:02 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050318#M352656 sunny_talwar 2016-01-21T20:19:02Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050319#M352657 <HTML><HEAD></HEAD><BODY><P>Can&nbsp; I do the same for the date,can I select the latest date among 2 dates ?</P></BODY></HTML> Thu, 21 Jan 2016 21:17:05 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050319#M352657 2016-01-21T21:17:05Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050320#M352658 <HTML><HEAD></HEAD><BODY><P>Sure you can, I think the only thing would be that Max(Date) would be an integer, if you want to see the date format, change it to <STRONG>Date(Max(Date))</STRONG></P></BODY></HTML> Thu, 21 Jan 2016 21:19:34 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050320#M352658 sunny_talwar 2016-01-21T21:19:34Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050321#M352659 <HTML><HEAD></HEAD><BODY><P>I Have max(sum(num)) ,but it still showing all 3</P></BODY></HTML> Thu, 21 Jan 2016 21:49:23 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050321#M352659 2016-01-21T21:49:23Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050322#M352660 <HTML><HEAD></HEAD><BODY><P>Not sure I understand.</P><P></P><P>You cannot double Aggregate without using Aggregation function. You need something similar to this: <STRONG>Max(Aggr(Sum(num), SomeDimension))</STRONG></P></BODY></HTML> Thu, 21 Jan 2016 21:51:54 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050322#M352660 sunny_talwar 2016-01-21T21:51:54Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050323#M352661 <HTML><HEAD></HEAD><BODY><P>DATE(MAX([Expiration Date],AB1Key))</P><P></P><P>Can I do something like this? My ABKey has multiple exp dates,so I only want to display the ABKey with the latest exp date .</P></BODY></HTML> Fri, 22 Jan 2016 21:20:09 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050323#M352661 2016-01-22T21:20:09Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050324#M352662 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>Date( RangeMax( Max([ExpirationDate]) , Max(AB1Key)))</P><P></P><P>This take the Max from the two fields.</P></BODY></HTML> Fri, 22 Jan 2016 21:41:08 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050324#M352662 Anonymous 2016-01-22T21:41:08Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050325#M352663 <HTML><HEAD></HEAD><BODY><P>Thank you Edagr,but this gives an error which says error in calculated dimension.</P></BODY></HTML> Sat, 23 Jan 2016 02:10:53 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050325#M352663 2016-01-23T02:10:53Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050326#M352664 <HTML><HEAD></HEAD><BODY><P>=Date(Max([Lease Expiration Date]) , (AB1Key))</P><P></P><P>I am using the above in my dimension along with other dimensions in the straight table,but the above dimension is giving error saying error in calculated dimension.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌</P></BODY></HTML> Sat, 23 Jan 2016 02:32:01 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050326#M352664 2016-01-23T02:32:01Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050327#M352665 <HTML><HEAD></HEAD><BODY><P>Not sure, but may be this:</P><P></P><P><STRONG>=Aggr(Date(Max([Lease Expiration Date])), AB1Key)</STRONG></P></BODY></HTML> Sat, 23 Jan 2016 03:49:16 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050327#M352665 sunny_talwar 2016-01-23T03:49:16Z Re: How to display the biggest of the numbers https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050328#M352666 <HTML><HEAD></HEAD><BODY><P>Sorry,but this is giving me the lease exp date instead of ABKey(which is my ID field)</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌</P></BODY></HTML> Sat, 23 Jan 2016 04:07:13 GMT https://community.qlik.com/t5/QlikView/How-to-display-the-biggest-of-the-numbers/m-p/1050328#M352666 2016-01-23T04:07:13Z