Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies