Sum up Forecast values based on Filterpane Calendarweek

[coerdn]

Hi together,

i have a filter pane were i can select the Calendarweek (Column Calendarweek). This Calendarweek reflects the reportingweek of the data. 

The Column Calendarweek_2 reflects the week for which the forecast values are reported.

No i want a graph which shows the forecast values. My idea was to take the Calenderweek and add +1,+2,+3

Example:

Calendarweek    Calendarweek_2   Value

33                              34                                 20

33                              35                                15

33                               36                             10

In my current formula qlik takes the correct result but i do not get any values. Can somebody help me or has a work around?

In this example in the Filterpane Calendarweek Calendarweek 33 is selected.

[Usama]

Hi,

Are you using the following expression:
Sum({<[Calendarweek_2]={$(=[Calendarweek]+1)}>}Value)

[coerdn]

Hi Usama,

yes i do.