0 Replies Latest reply: Aug 12, 2014 7:32 PM by Grace Xia RSS

    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