topic Max Date by Row? in QlikView

Max Date by Row?

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

Hello,

I have the following table:

Month Year	=num(monthstart(max(CALE_DATE),1))	*=sum({<EVENT={'BACKLOG'},BETA={">=43160"}>} QTY_INC)*
Jul-2017	42948	0
Ago-2017	42979	0
Sep-2017	43009	0
Oct-2017	43040	0
Nov-2017	43070	0
Dic-2017	43101	0
Ene-2018	43132	0
Feb-2018	43160	0

The thing is Expression 2 isn't working well, because BETA field value is 43160 (fixed) and it should be the max value from each row (see expression 1).

I used this:

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(CALE_DATE),1)))"}>} QTY_INC)

Do you know how could I do to use the max for each MonthYear?

Thank you!!!

Re: Max Date by Row?

sunny_talwar — Mon, 26 Feb 2018 15:31:05 GMT

May be using Aggr()

Sum({<EVENT={'BACKLOG'}>} Aggr(If(BETA >= MonthStart(Max(CALE_DATE), 1), Sum({<EVENT={'BACKLOG'}>} QTY_INC)), BETA, [Month Year]))

Re: Max Date by Row?

Anil_Babu_Samineni — Mon, 26 Feb 2018 15:31:33 GMT

May be this?

sum({<EVENT={'BACKLOG'},BETA={">=$(=num(monthstart(max(TOTAL CALE_DATE),1)))"}>} QTY_INC)

Or else, Can you check this in text box?

num(monthstart(max(TOTAL CALE_DATE),1))