Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
waszcma1
Partner - Creator II
Partner - Creator II

Cumulative sums of workload

Hi,

I have been asked to create line graph with information about workload 

Business asked me to create cumulative sum which is no problem (see table second column)

But additional to that I have drop numbers for RFC which go-Live date is passed

i.e.:
we have created
2022-01  18 RFC (most of RFC have go live after 5-6 month but 2 of them have go live on 2022-02)
2022-02  9 RFC ( all of RFC have go live after 5-6 month)
2022-03  4 RFC ( all of RFC have go live after 5-6 month)

so I want to reported on 2022-03 (18-2)+9+4 = 29

Currently cumulative sum is not including the second conndition and returns  18+9+4=31 

waszcma1_0-1664467688591.png

Any Idea how to achieve this?

Labels (1)
0 Replies