Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
Do you have any idea ?
Thanks a lot
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]))
Question: Why only 388 and not 389, 390 ..
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