0 Replies Latest reply: Aug 31, 2015 6:04 AM by sandy kalmijn RSS

    Total annual premium by more coverages each policynumber

      Dear reader,


      For an insurance company I want to create a qlikviewdashboard. It is my first
      dashboard so maybe the question I have is simple.


      I want to know the total annual premium and the total number of coverages.

      I made a standard table with by expressions the sum of coverages witch are calculated.

      Some of the policynumbers has more separate coverages with each coverage an own prize.

      I want to know the total annual premium but if there are more coverages at one
      policynumber not all the prizes are included so the wrong total annual premium
      is at my display.


      I hope you have the solution for me. 

      English is not my first language so I also hope that you know what I mean.


      Best regards,

      Sandy Kalmijn