Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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