Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Are you using the following expression:
Sum({<[Calendarweek_2]={$(=[Calendarweek]+1)}>}Value)
Hi Usama,
yes i do.