2 Replies Latest reply: Aug 2, 2013 4:18 PM by qlikblue RSS

    Ignore Values in Time Series Chart

      Hi,

       

      I have a time series chart that uses date values formatted as year + week number (yyyyww), but my chart is including week numbers between 53 and 99 (which obviously don't exist) and shows huge gaps in my data as a result.  Is there a way to automatically skip over these values and go straight from week 52 of one year to week 1 of the following year?

       

      I've tried various dimension limits but with no success.  Any help is much appreciated!

        • Re: Ignore Values in Time Series Chart
          Gysbert Wassenaar

          Try creating the year-week field as: dual(weekyear(MyDate)&week(MyDate),weekstart(MyDate)). That should get rid of the weird week values

            • Re: Ignore Values in Time Series Chart

              Thanks for your help, Gysbert!  I gave it a shot but had the same issue, it's still returning the same week numbers. 

               

              If I uncheck 'Continuous' in Properties->Axes then those values go away, but then the chart doesn't fit in a single window (it requires scrolling be enabled).  With 'Continuous' checked it behaves the way I was looking for (everything fits in the window regardless of how big the object is) but then it returns those values.

               

              The alternative is to uncheck continuous and expand the chart size.  Not ideal, but can't find any other way to exclude those values.