Calendar Ideas

Mon, 27 Oct 2014 08:54:17 GMT

Morning All,

Looking for some ideas on a bit of a quirky problem.

I have a relatively simple insurance data set made of 2 tables policy revenue and policy payments (claims). Both tables have a "Date" column" i.e. date when policy revenue (premiums) are paid and date when a claim is paid respectively.The natural link is obviously policy number.

The problem I have here is that I would like to compare premiums and revenues lets say either by year or month. What is the best way to handle these 2 differing dates? I need to have a list box where I can either select a month or year and I will have both claims and premiums for that period.

A single calendar would be difficult because you would have to choose an association by either claims date of premiums date when you want both.

Hope this makes sense.

Thanks

Re: Calendar Ideas

ecolomer — Mon, 27 Oct 2014 09:00:37 GMT

You need use Master Calendar

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

topic Re: Calendar Ideas in QlikView

Calendar Ideas

Re: Calendar Ideas