topic Re: Inventory Days issue on Chart in QlikView

Inventory Days issue on Chart

Venkatesh_5990 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

We are using Inventory days as month wise, the formula is like current month closing value/last three months avg sales value. For this logic we are using two different areas like Text Object and Graph (Cyclic group : Quater & Month).
The below logic is using for Inventory days by months it is working fine when in Text Object but it is not working in Graph.Users are expecting only Monthwise Inventory days only not Quarterwise Inventory days. Any one can help me on this?

=num(Sum({<Month={$(=Month)}>}(Closing_Value/1000))
/ (sum({<Month={">=$(=max(Month)-2)<=$(=max(Month))"}>}(Sales_Value/1000))/3)*30,'#,##0')

Thanks in advance!

Re: Inventory Days issue on Chart

sunny_talwar — Fri, 16 Oct 2020 12:08:47 GMT

@Venkatesh_5990 Would you be able to share a sample where we can see the issue?

Re: Inventory Days issue on Chart

benvatvandata — Fri, 16 Oct 2020 17:04:20 GMT

A sample would definitely help... have you tried doing:

=num(Sum({<Month={$(=Month)}>} total <Month> (Closing_Value/1000))
/ (sum({<Month={">=$(=max(Month)-2)<=$(=max(Month))"}>}(Sales_Value/1000))/3)*30,'#,##0')

(I added "total <Month>" to the first part of the expression to see if it would get the total for the month and not the quarter)

Re: Inventory Days issue on Chart

Venkatesh_5990 — Sat, 17 Oct 2020 04:04:40 GMT

Hi @sunny_talwar & @benvatvandata ,

Please find the below screenshot, above given script is also showing same value only.

Re: Inventory Days issue on Chart

Brett_Bleess — Tue, 27 Oct 2020 18:54:37 GMT

@Venkatesh_5990 likely going to need sample QVW file, not just screenshot, as likely need to see data model as well as chart and properties on this one in order to try to sort it if what they already posted did not work.

Regards,
Brett