Week to date expression

[#1]

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:

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!

[#2]

MDX -->

Calendar  = Hierarchy

Year = Level in hierarchy

Currentmember = current location in hierarchy

[#3]

These expression is satisfied?

[#4]

No, this is an expression which I have build in OLAP, and I want the same functionality in QlikView. I do not know how this can be acheived. Sum({YTD(Calendar.Year.Currentmember, Calendar.CurrentMember)} Sales) is a MDX query statement. I want to translate this to a QlikView statement.

[#5]

You have any field name for week in qlikview or have to create?