Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
bouzp2019re
Contributor
Contributor

Data vizualisation about leadtime accumulate

Hi everyone, 

I started to use Qlik recently so i am still new at this 🙂 I am trying to do a curve about lead time. Indeed my table is like this :

Lead Time (in days)        Number of reservation  

390                                                            5

389                                                             1

388                                                             3

.......

1                                                                  52

 

In my curve i would like to represent the number of reservation by lead time but in addition. For exemple in my curve

for 388 days i would like to have 9 reservations ( 5+1+3). The result would look like that : 

MEC.png

 

Do you have any idea ?

 

Thanks a lot 

2 Replies
Anil_Babu_Samineni

IF you ask me, I would simply logic manual like

If([Lead Time (in days)]='388', Sum({<[Lead Time (in days)]={390, 389, 388}>} [Number of reservation]), Sum([Number of reservation]))

QuestionWhy only 388 and not 389, 390 ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bouzp2019re
Contributor
Contributor
Author

Thanks for your answer 🙂 Maybe i did not explain well. 

In my table i have like 390 observations. The column LeadTim has all day from 1 to 390. And each time i want to cumulate.

 

Thanks