topic Selecting 1 record from 2 possible by comparing the two in QlikView https://community.qlik.com/t5/QlikView/Selecting-1-record-from-2-possible-by-comparing-the-two/m-p/128287#M601412 <HTML><HEAD></HEAD><BODY><P>I have 2 tables:</P><P>CARD:</P><P>Card_ID</P><P>SETUP_DT</P><P>CLEANUP_DT</P><P></P><P>SELECTED_CARD:</P><P>CARD_ID</P><P>CASE_COMFIRMATION_ID</P><P></P><P></P><P>Sometimes more then one card is selected per confirmation_id I I want to only grab the larger of the setup and clean up times.</P><P></P><P></P><P>If a card has a 15 minute setup time and another 30 minute cleanup time then the 30 minute one is the only one selected. </P></BODY></HTML> Tue, 02 Oct 2018 17:26:09 GMT Anonymous 2018-10-02T17:26:09Z Selecting 1 record from 2 possible by comparing the two https://community.qlik.com/t5/QlikView/Selecting-1-record-from-2-possible-by-comparing-the-two/m-p/128287#M601412 <HTML><HEAD></HEAD><BODY><P>I have 2 tables:</P><P>CARD:</P><P>Card_ID</P><P>SETUP_DT</P><P>CLEANUP_DT</P><P></P><P>SELECTED_CARD:</P><P>CARD_ID</P><P>CASE_COMFIRMATION_ID</P><P></P><P></P><P>Sometimes more then one card is selected per confirmation_id I I want to only grab the larger of the setup and clean up times.</P><P></P><P></P><P>If a card has a 15 minute setup time and another 30 minute cleanup time then the 30 minute one is the only one selected. </P></BODY></HTML> Tue, 02 Oct 2018 17:26:09 GMT https://community.qlik.com/t5/QlikView/Selecting-1-record-from-2-possible-by-comparing-the-two/m-p/128287#M601412 Anonymous 2018-10-02T17:26:09Z