topic Re: Set analysis max date in QlikView

Set analysis max date

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

I have a lines of sales and a price list on a specific date. The sales row has a field [Posting Date], the price list has [Start Date] field and the [Net Purchase Price].
Each line of sales should be added [Net Purchase Price] from the lines of the price list with the highest date.

e.g. Max([Starting Date]) <=[Posting Date]

TIA
Igor

Re: Set analysis max date

agni_gold — Thu, 22 Nov 2018 13:48:25 GMT

can you please explain with some sample data and required output.

Re: Set analysis max date

thepiapus — Thu, 22 Nov 2018 14:26:39 GMT

I must add field Net Purchase price to each row on certain date.

Re: Set analysis max date

sunny_talwar — Fri, 23 Nov 2018 13:09:53 GMT

Try this expression

Sum(Aggr(
If(Max(TOTAL <Description, [Document No_], Lot, No_, [Posting Date], Vendor> If([Starting Date] <= [Posting Date], [Starting Date])) = [Starting Date], [Net Purchase Price])
, Description, [Document No_], Lot, No_, [Posting Date], Vendor, [Starting Date]))

Re: Set analysis max date

thepiapus — Mon, 26 Nov 2018 07:47:30 GMT

Thanks a lot, you made my day 🙂