Discussion Board for collaboration related to Creating Analytics for QlikView.
For an insurance company I want to create a qlikviewdashboard. It is my firstdashboard 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 onepolicynumber not all the prizes are included so the wrong total annual premiumis 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.