Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
coerdn
Partner
Partner

Sum up Forecast values based on Filterpane Calendarweek

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.

coerdn_0-1599346547468.png

 

 

2 Replies
Usama
Creator
Creator

Hi,

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


From Nothing - To Something - To Everything
coerdn
Partner
Partner
Author

Hi Usama,

yes i do.