13 Replies Latest reply: Mar 15, 2013 8:14 AM by Nirmal Raj RSS

    Week to date expression

      Hello,

       

      For a report that I am making I need the following:

       

      I have a graph, which shows our sales over the weeks, and I want to show a cummulative measure which sums from week 1 to the current week in the graph

      , see image:

      WTD.JPG

       

      The Blue line is the WTD, I only calculated it in my dataset, which makes the query very slow. Is there a way to let Qlikview calculate the WTD, and how can I do that? When I need to make a WTD measure in my dataset for every cumulative measure, the performance will be dramatic.

       

      Thanks!