https://community.qlik.com/t5/QlikView/Message-will-displaye-when-click-on-record-in-qlikview/m-p/1604436#M456539 <DIV class="post-text"><P>I have records like this</P><P><A href="https://i.stack.imgur.com/Bd4kY.png" rel="nofollow noreferrer" target="_blank"><IMG src="https://i.stack.imgur.com/Bd4kY.png" border="0" alt="image" /></A></P><P>In above record you see that top 4 records assume that these 4 policies are not in previous year i.e. 2017 so this is new business .</P><P>5th and 6th records their policy no are not found in records nor in previous and not in next year this is lost business</P><P>and last 2 records p no 122 then again in next record is 122-1 this is renewed business</P><P>so from here i want to find out when P no did not found again in records then consider this lost business so i want when i click on that records then message should displayed "LOST"</P><P>this is link of folder</P><P><A href="https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0" rel="nofollow noreferrer" target="_blank">https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0</A></P></DIV> Sat, 16 Nov 2024 02:57:04 GMT capriconuser 2024-11-16T02:57:04Z https://community.qlik.com/t5/QlikView/Message-will-displaye-when-click-on-record-in-qlikview/m-p/1604436#M456539 <DIV class="post-text"><P>I have records like this</P><P><A href="https://i.stack.imgur.com/Bd4kY.png" rel="nofollow noreferrer" target="_blank"><IMG src="https://i.stack.imgur.com/Bd4kY.png" border="0" alt="image" /></A></P><P>In above record you see that top 4 records assume that these 4 policies are not in previous year i.e. 2017 so this is new business .</P><P>5th and 6th records their policy no are not found in records nor in previous and not in next year this is lost business</P><P>and last 2 records p no 122 then again in next record is 122-1 this is renewed business</P><P>so from here i want to find out when P no did not found again in records then consider this lost business so i want when i click on that records then message should displayed "LOST"</P><P>this is link of folder</P><P><A href="https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0" rel="nofollow noreferrer" target="_blank">https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0</A></P></DIV> Sat, 16 Nov 2024 02:57:04 GMT https://community.qlik.com/t5/QlikView/Message-will-displaye-when-click-on-record-in-qlikview/m-p/1604436#M456539 capriconuser 2024-11-16T02:57:04Z https://community.qlik.com/t5/QlikView/Message-will-displaye-when-click-on-record-in-qlikview/m-p/1604921#M456540 <P>any help</P> Tue, 23 Jul 2019 05:49:51 GMT https://community.qlik.com/t5/QlikView/Message-will-displaye-when-click-on-record-in-qlikview/m-p/1604921#M456540 capriconuser 2019-07-23T05:49:51Z