topic Re: Calculate inventory when using date related dimensions. in QlikView

Calculate inventory when using date related dimensions.

snoopyboy2599 — Mon, 11 Jul 2011 03:16:09 GMT

Hi all,

When I display the inventory, I want to use date related dimensions, such as year, quarter, month, dates, in the table.

If I use expression like Sum( { $< date = { '$(= Max (date) )' } > } Inventory), it will only return the last row correctly and others will be 0s like below.

What I want to see is like this:

Month Inventory

1 30

2 3000

I understand it's because $(= Max (date) ) = 22, but how do I alter it?

Any ideas?

Thanks in advance.

(above example in attachment)

Calculate inventory when using date related dimensions.

snoopyboy2599 — Tue, 12 Jul 2011 14:13:01 GMT

Anyone？

Re: Calculate inventory when using date related dimensions.

snoopyboy2599 — Wed, 13 Jul 2011 03:20:50 GMT

Ok, solved it myself (poor me, no one answers).

The expression should be:

FirstSortedValue(Distinct Aggr(Sum(INVENTORY),DAY),-DAY)