Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Amount of days in inventory

Solved.

See the example in attachment.

regards,

Raf

2 Replies
Not applicable

Re: Amount of days in inventory

any ideas?

Not applicable

Re: Amount of days in inventory

Solved.

See the example in attachment.

regards,

Raf

Community Browser