topic Re: firstsortedvalue return nothing in QlikView https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108246#M463412 <HTML><HEAD></HEAD><BODY><P>If you have two highest <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #edf8ca;">[FoB Price] value, the below expression will return null</STRONG></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #edf8ca;">=FirstSortedValue(Key</SPAN><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #edf8ca;">,-[FoB Price],1)</STRONG></P></BODY></HTML> Thu, 07 Jul 2016 08:54:05 GMT MK_QSL 2016-07-07T08:54:05Z firstsortedvalue return nothing https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108242#M463408 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/130426_Capture.JPG" style="height: auto; width: auto;" /></P><P>Good afternoon guys, are there something wrong with my syntax? Thanks!</P></BODY></HTML> Thu, 07 Jul 2016 07:53:56 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108242#M463408 2016-07-07T07:53:56Z Re: firstsortedvalue return nothing https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108243#M463409 <HTML><HEAD></HEAD><BODY><P>try below</P><P></P><P>=FirstSortedValue(Key<STRONG>,-[FoB Price],1)</STRONG></P></BODY></HTML> Thu, 07 Jul 2016 07:57:35 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108243#M463409 Chanty4u 2016-07-07T07:57:35Z Re: firstsortedvalue return nothing https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108244#M463410 <HTML><HEAD></HEAD><BODY><P>Try</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">=FirstSortedValue(Distinct Key<SPAN style="font-style: inherit; font-family: inherit;"><STRONG>,-[FoB Price],1)</STRONG></SPAN></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-style: inherit; font-family: inherit;"><STRONG>or</STRONG></SPAN></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-style: inherit; font-family: inherit;"><STRONG><SPAN style="font-size: 13.3333px;">=FirstSortedValue(Distinct Key</SPAN><SPAN style="font-style: inherit; font-family: inherit;"><STRONG>,[FoB Price])</STRONG></SPAN></STRONG></SPAN></P></BODY></HTML> Thu, 07 Jul 2016 08:01:22 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108244#M463410 MK_QSL 2016-07-07T08:01:22Z Re: firstsortedvalue return nothing https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108245#M463411 <HTML><HEAD></HEAD><BODY><P>Or</P><P>Concat(Distinct If(<STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">[FoB Price] = Min(Total <STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">[FoB Price]), Key),', ')</STRONG></STRONG></STRONG></STRONG></P><P><STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;"><STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">or</STRONG></STRONG></STRONG></STRONG></P><P style="font-size: 13.3333px;">Concat(Distinct If(<STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">[FoB Price] = Max(Total <STRONG style="color: #3d3d3d; font-size: 13px; font-style: inherit; font-family: inherit; font-weight: inherit;"><STRONG style="font-style: inherit; font-family: inherit;">[FoB Price]), Key),', ')</STRONG></STRONG></STRONG></STRONG></P></BODY></HTML> Thu, 07 Jul 2016 08:03:24 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108245#M463411 MK_QSL 2016-07-07T08:03:24Z Re: firstsortedvalue return nothing https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108246#M463412 <HTML><HEAD></HEAD><BODY><P>If you have two highest <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #edf8ca;">[FoB Price] value, the below expression will return null</STRONG></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #edf8ca;">=FirstSortedValue(Key</SPAN><STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #edf8ca;">,-[FoB Price],1)</STRONG></P></BODY></HTML> Thu, 07 Jul 2016 08:54:05 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-return-nothing/m-p/1108246#M463412 MK_QSL 2016-07-07T08:54:05Z