topic After selection, selecting single row from the result set based on the condition. in QlikView https://community.qlik.com/t5/QlikView/After-selection-selecting-single-row-from-the-result-set-based/m-p/321072#M118302 <HTML><HEAD></HEAD><BODY><P>Hi Everyone, </P><P></P><P>Scenario: I have loaded list of clients and their history related to the licenses purchased/renewed by them. When user selects any single client, then I am showing history table for the selected client, which may have single or multiple records related to all the licenses he has purchased/renewed in the history. Now from this result set, I want to select single row based on the condition. Condition may be like selecting a row from the result set where expiry date is yet to come, and if license was already expired then selecting a row from the result set where the license was expired most recently.</P><P></P><P>After this, I want to represent this row data in a various form. I hope I put the problem correctly. I dont know whether I have to use set analysis for this. Any help would be greatly appreciated. Thanks in advance.</P></BODY></HTML> Mon, 01 Aug 2011 12:01:37 GMT 2011-08-01T12:01:37Z After selection, selecting single row from the result set based on the condition. https://community.qlik.com/t5/QlikView/After-selection-selecting-single-row-from-the-result-set-based/m-p/321072#M118302 <HTML><HEAD></HEAD><BODY><P>Hi Everyone, </P><P></P><P>Scenario: I have loaded list of clients and their history related to the licenses purchased/renewed by them. When user selects any single client, then I am showing history table for the selected client, which may have single or multiple records related to all the licenses he has purchased/renewed in the history. Now from this result set, I want to select single row based on the condition. Condition may be like selecting a row from the result set where expiry date is yet to come, and if license was already expired then selecting a row from the result set where the license was expired most recently.</P><P></P><P>After this, I want to represent this row data in a various form. I hope I put the problem correctly. I dont know whether I have to use set analysis for this. Any help would be greatly appreciated. Thanks in advance.</P></BODY></HTML> Mon, 01 Aug 2011 12:01:37 GMT https://community.qlik.com/t5/QlikView/After-selection-selecting-single-row-from-the-result-set-based/m-p/321072#M118302 2011-08-01T12:01:37Z