Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Data at different levels of Granularity

Hi all,

I have 2 tables relating to insurance ClAIMS and PREMIUMS. Unfortunately we do NOT have data at POLICY level which would have been ideal as we will then have a nice 1-to-many relationship to do all our reporting, agreegations etc.

Instead we have just 2 tables that store data at different levels of granularity - I have colour coded all the equivalent fields from each table.

test2.jpg

Common sense told me to create a composite key comprising Agent+Year+Use+Region+Category which DOES create an association between the tables but leads to not only erroatic results but also erratic behaviour.

One such example of erratic behaviour is a pie chart for example where:

Dimension: Premium.PremiumCategory

Expression: Sum(Premiums.NetPremium)

test3.jpg

The pie chart may look accurate and functional but it does not allow me, for example, to click on any of the pie segments to select a category. I am assuming that this is because it is getting in some kind of cyclical or circular reference. Most bizarre.

How would you deal with this granularity issue where my PREMIUM data is made available in SUMMARY form and the ClAIMS data in DETAIL form and are being deprived of the single field that would form the connector in all this, the PolicyNo?

Thanx

Alexis

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Data at different levels of Granularity

In the end with the help of the very helpful Nicolas Martin we resolved this using concatenation of the tables.

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Data at different levels of Granularity

Perhaps this blog post can help you find a way to deal with your problem.


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

Re: Data at different levels of Granularity

Thanks Gysbert.

I saw this many months ago but now it's more relevant then ever!

regards

Alexis

Highlighted
Partner
Partner

Re: Data at different levels of Granularity

In the end with the help of the very helpful Nicolas Martin we resolved this using concatenation of the tables.

View solution in original post