https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547105#M39393 <P>PRICESTRUCTUREID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PRICE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CODE</P><P>11065&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/29/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100PRF</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/14/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CLUB</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/20/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300LV3</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/31/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV3</P><P>11064&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV4</P><P>11072&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300LV5</P><P>11059&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300LV3</P> Wed, 20 Feb 2019 20:14:40 GMT EvanBarrick 2019-02-20T20:14:40Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547066#M39386 <P>I have a table of data that appears as such:</P><P>priceSTRUCTUREID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PriceCODE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date (mm/dd/yyyy)</P><P>1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/1/2019</P><P>1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/15/2019</P><P>1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2/20/2019</P><P>&nbsp;</P><P>I want to build an expression that would generate the result for 'Price' based on the most recent date, which in this case would be 40</P> Wed, 20 Feb 2019 18:43:17 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547066#M39386 EvanBarrick 2019-02-20T18:43:17Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547068#M39387 <P>May be this</P><PRE>FirstSortedValue(Price, -Date)</PRE> Wed, 20 Feb 2019 18:51:59 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547068#M39387 sunny_talwar 2019-02-20T18:51:59Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547075#M39389 <P>This expression will be placed in a table. The Dimension is 'PRICECODE'</P><P>When I enter your expression, no output is generated</P> Wed, 20 Feb 2019 19:06:01 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547075#M39389 EvanBarrick 2019-02-20T19:06:01Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547088#M39390 <P>With the sample data you have provided, I don't see why the expression I have provided won't work. I am sure something else which you might not have shared in the sample data might be causing this. Can you share a better sample data?</P> Wed, 20 Feb 2019 19:19:20 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547088#M39390 sunny_talwar 2019-02-20T19:19:20Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547103#M39392 <P>STRUCTUREID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PRICE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CODE</P><P>11065&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/29/2015&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100PRF</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/14/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CLUB</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/14/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300LV3</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/20/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV3</P><P>11064&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/31/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV4</P><P>11072&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/02/2019&nbsp; &nbsp; &nbsp; &nbsp; 300LV5</P><P>11059&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/03/2108&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300LV3</P> Wed, 20 Feb 2019 20:06:05 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547103#M39392 EvanBarrick 2019-02-20T20:06:05Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547105#M39393 <P>PRICESTRUCTUREID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PRICE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CODE</P><P>11065&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;85&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/29/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100PRF</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/14/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CLUB</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/20/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300LV3</P><P>11069&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;55&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/31/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV3</P><P>11064&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 60&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100LV4</P><P>11072&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/03/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300LV5</P><P>11059&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300LV3</P> Wed, 20 Feb 2019 20:14:40 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547105#M39393 EvanBarrick 2019-02-20T20:14:40Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547110#M39394 <P>I attempted to respond with more data, but it was marked as spam</P> Wed, 20 Feb 2019 20:29:33 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547110#M39394 EvanBarrick 2019-02-20T20:29:33Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547115#M39395 <P>Post it as an Excel file</P> Wed, 20 Feb 2019 20:40:31 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547115#M39395 sunny_talwar 2019-02-20T20:40:31Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547117#M39396 Wed, 20 Feb 2019 20:47:12 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547117#M39396 EvanBarrick 2019-02-20T20:47:12Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547119#M39398 <P>So, Code is the dimension here and you would want something like this</P><P>Code&nbsp; &nbsp; &nbsp; &nbsp; Price<BR />100LV3&nbsp; &nbsp; &nbsp;60<BR />300LV2&nbsp; &nbsp; &nbsp;75<BR />100LV2&nbsp; &nbsp; &nbsp;155<BR />CLUB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;80<BR />100PRF&nbsp; &nbsp; &nbsp;90</P><P>My expression still holds</P><PRE>FirstSortedValue(Price, -Date)</PRE> Wed, 20 Feb 2019 20:56:14 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547119#M39398 sunny_talwar 2019-02-20T20:56:14Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547123#M39399 <P>Thanks for the reply, but the expression is not working. I have tried a simple expression of =MAX(PRICE) and that returns the highest price. Not sure where else the problem would lie</P> Wed, 20 Feb 2019 21:01:08 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547123#M39399 EvanBarrick 2019-02-20T21:01:08Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547467#M39416 <P>Unless you can share a sample where I can see the problem, I am afraid I won't be able to offer much help.</P> Thu, 21 Feb 2019 12:05:45 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547467#M39416 sunny_talwar 2019-02-21T12:05:45Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547630#M39432 <P>I cannot share my app as I cannot export the application</P> Thu, 21 Feb 2019 16:07:50 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547630#M39432 EvanBarrick 2019-02-21T16:07:50Z https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547633#M39433 <P>okay</P> Thu, 21 Feb 2019 16:13:29 GMT https://community.qlik.com/t5/App-Development/IF-Expression-Based-on-Most-Recent-Date/m-p/1547633#M39433 sunny_talwar 2019-02-21T16:13:29Z