Discussion Board for collaboration on QlikView Layout & Visualizations.
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,
Go to Solution.
See the example in attachment.