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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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