3 Replies Latest reply: Jun 23, 2011 7:05 AM by rodrigomurta RSS

    Arbitrary Range Sum with Set Analysis (Easy YTD calc.)

      Hi QlikHeads!

      How can you use a field value (e.g. week) instead of a fixed value in the Set Analysis expression for summing over an interval?

      Pls. see enclosed example: Imagine that we have 5 weeks associated with values. When I select a week(or range) I want my set analysis to make a sum of all values from W0 -> max(week).

      In the example it works with a fixed value (e.g. '4') but how can I use the Field "Week"?

      error loading image

      Regards,

      Lars Madsen