topic Re: previous(inventory) sorting issue in QlikView

previous(inventory) sorting issue

Tue, 19 Jan 2016 20:06:07 GMT

Hi all,

I am trying to calculate inventory turns (((this week inventory+ last week inventory)/2)/sales). To calculate the inventory I am using the previous(inventory) function so that I get the last week Inventory. But the issue is I have many dimensions where I will be using apart from the week dimesion. for ex: dept, store, and few more. issue is with sorting of previous(inventory) it is no where related .

can anybody help me with this issue?

Thanks in advance

Re: previous(inventory) sorting issue

sunny_talwar — Tue, 19 Jan 2016 21:02:27 GMT

Do you have a sample app where you can show the issue?

Re: previous(inventory) sorting issue

Tue, 19 Jan 2016 22:38:30 GMT

Hi I am attaching a test file as well. Please let me know your insights on this issue.

Re: previous(inventory) sorting issue

swuehl — Tue, 19 Jan 2016 23:16:10 GMT

What would be the expected result for your sample data?

In general, if you want to use Previous() / Peek() in the script, you need to order your data records accordingly and then you might need to check for changes in column segments (i,e, changes in Dimension values other than week number).

If you need to be dynamic with your inventory calculation (i.e. you can't calculate it in the script because it depends on selections / changing dimensions), you can use Above() chart inter record function, analog to Peek() in the script.

Re: previous(inventory) sorting issue

Wed, 20 Jan 2016 18:52:59 GMT

Hi swuehl,

Can you please share the expression?

Re: previous(inventory) sorting issue

Wed, 20 Jan 2016 19:08:37 GMT

Hi guys,

I am attaching the expected result set

Thanks

Re: previous(inventory) sorting issue

sunny_talwar — Thu, 21 Jan 2016 10:01:36 GMT

I don't see the store, dept...etc information in the qvw, but those are used as dimensions in your excel file. Not sure if I can replicate the Excel into your qvw without all the fields.

Re: previous(inventory) sorting issue

Thu, 21 Jan 2016 17:05:30 GMT

Hi Sunny,

I have uploaded the latest copy with all the dimensions