Cumulative up until a certain point

[#1]

Hey all,

I want to have a line graph with as dimensions the week of the year and with three expressions:

- sales from 2010

- sales from 2011

- sales from 2012

The first two should be 'full accumulation' but the last one should stop in the current week.

When I would create this the logical way then I have a horizontal line for the last expression from the current week untill the end of the year.

How do I solve this?

Thank you!

[lironbaram · Accepted solution]

hei attach is an example

heav a look may be it helps you

[#3]

Ok Thank you Baram, so the solution was to have two dimensions: one for the year and one for the week and to have only one expression.

[lironbaram]

yes

as rule of thumb

i'll try to use the simpler solution there is in qlikview

the model would work faster that way