topic Re: STRAIGHT TABLE ISSUE in QlikView https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006266#M341771 <HTML><HEAD></HEAD><BODY><P>Can you please update my sample and attach here</P></BODY></HTML> Sun, 13 Dec 2015 23:14:07 GMT 2015-12-13T23:14:07Z STRAIGHT TABLE ISSUE https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006264#M341769 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a data which includes Policynum and Module. When the policy renewes it is assigned a new mod .</P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In the attached sample&nbsp; Policynum '1701655 '&nbsp; have 10 modules.&nbsp; I want the data set to always come back with only the latest module entries.</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">In the attached sample I would like to see only one row for each policy</P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">PSL 1701655 does not show any No.Of Docs&nbsp; but&nbsp; Policy Number 0114166 does show that&nbsp; .I am able to see No. of Docs for Policy Num 1701655 if I click on Policy Number filter.&nbsp;&nbsp; How&nbsp; can I make the No of Docs visible all times for the Latest Mod for each Policy.</P></BODY></HTML> Sun, 13 Dec 2015 20:26:35 GMT https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006264#M341769 2015-12-13T20:26:35Z Re: STRAIGHT TABLE ISSUE https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006265#M341770 <HTML><HEAD></HEAD><BODY><P>You may create an expression like:</P><P>FirstSortedValue(NO_DOC_REN,-Aggr(Max(POLICY_MODULE),LOB,[Policy Num],POLICY_MODULE))</P></BODY></HTML> Sun, 13 Dec 2015 22:12:29 GMT https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006265#M341770 jolivares 2015-12-13T22:12:29Z Re: STRAIGHT TABLE ISSUE https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006266#M341771 <HTML><HEAD></HEAD><BODY><P>Can you please update my sample and attach here</P></BODY></HTML> Sun, 13 Dec 2015 23:14:07 GMT https://community.qlik.com/t5/QlikView/STRAIGHT-TABLE-ISSUE/m-p/1006266#M341771 2015-12-13T23:14:07Z