Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Community Browser