Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Build up a line chart for multi-field (Quaterly development over year)

Hi All,

What I'm trying to do is to create a line chart for the quaterly development claims for each underwriting years(UWYear), i.e. each UWYear) is one of the measures and the dimension being the quaters. In addition, I should be able to aggregate the claims according to different characteristics, e.g. PolicyNo, Country and Triggers. However, the data structure I've got is that the UWYear and the Quaters actually form a matrix, i.e. the quaters are different fields.

Since I'm new to Qlikview, I got really confused about how to achieve the goal. I've attached a demo for you to better understand what I mean. Would be really appreciated if you could give me any suggestions.

Many thanks,

Grace 

Community Browser