Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Amount of days in inventory

Hi experts,

I would like to make a bar chart which displays the amount of days that it will take for a stock unit to be completed. But I can't find the formula.

Data is on monthly basis.For the last month, the forecast can be devided by 30 to get the average to calculate the days.

I have a measure [stock begin month] and for each month a [forecast of stock sold] measure.

This with month as a dimension.

What is the best way to do this? With a loop in the script?

Thanks in advance,

Raf

1 Solution

Accepted Solutions
Not applicable
Author

Solved.

See the example in attachment.

regards,

Raf

View solution in original post

2 Replies
Not applicable
Author

any ideas?

Not applicable
Author

Solved.

See the example in attachment.

regards,

Raf