9 Replies Latest reply: Feb 18, 2014 4:15 PM by Xuan Yang RSS

    exclude a few data points from one of the few lines in a line chart

    Xuan Yang

      Hi there, firstly thanks for your time! This question has being holding off my work for days...

      I have a line chart, x-axis is week number, y-axis is insurance take-rate(one line for [fiscal] = 2014, the other for [fiscal] = 2013).

      Since the latest [week number] for FY14 is 75, the value of insurance take-rate is not valid for any week with a [week number] larger than 75, and you can see it's all flat when the [week number] is >= 75.

      What I need to solve is to exclude those data points where the [week number] is >= 75 AND ONLY FOR [fiscal] = 2014; I don't want to do any change on [fiscal] = 2013 since for 2013, all value is valid.

       

      The data points need to be excluded is shown in the following chart, and I attached the excel & qvw file here.

      Please let me know if you have any hints or solutions!


      Thanks!

      Xuan

       

      2014-02-18_1412.png