Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor

Logic to count insurances with current status

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 ({<[Portfolio.State] = {'Valid'}>} Portfolio.Policy ) I get an extremely minor result of policies per month-year against the actual data that I would have to arrive to.

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?

  I appreciate your help greatly greetings

1 Reply

Re: Logic to count insurances with current status

Would you be able to share a sample to show the issue?