topic Re: Logic to count insurances with current status in QlikView https://community.qlik.com/t5/QlikView/Logic-to-count-insurances-with-current-status/m-p/130157#M759364 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to show the issue?</P></BODY></HTML> Fri, 10 Aug 2018 18:44:46 GMT sunny_talwar 2018-08-10T18:44:46Z Logic to count insurances with current status https://community.qlik.com/t5/QlikView/Logic-to-count-insurances-with-current-status/m-p/130156#M759363 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="color: black;">Hi. I am analyzing the information of a business. This is complex in terms of the logic of the statuses of insurance plans, since I need to generate a current policy count table by month-year and by making a simple expression Count ({&lt;[Portfolio.State] = {'Valid'}&gt;} Portfolio.Policy ) I get an extremely minor result of policies per month-year against the actual data that I would have to arrive to.</SPAN></P><P></P><P><SPAN lang="EN-US" style="color: black;">I have the fields of DateEmission and DateEnd of the policies so I think to create a logic that plays with these fields. What do you advise me to develop this table?</SPAN></P><P></P><P>&nbsp; <SPAN lang="EN-US" style="font-size: 11.0pt; font-family: 'Calibri',sans-serif; color: black;">I appreciate your help greatly greetings</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic-to-count-insurances-with-current-status/m-p/130156#M759363 Anonymous 2020-11-25T16:16:04Z Re: Logic to count insurances with current status https://community.qlik.com/t5/QlikView/Logic-to-count-insurances-with-current-status/m-p/130157#M759364 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample to show the issue?</P></BODY></HTML> Fri, 10 Aug 2018 18:44:46 GMT https://community.qlik.com/t5/QlikView/Logic-to-count-insurances-with-current-status/m-p/130157#M759364 sunny_talwar 2018-08-10T18:44:46Z