topic Re: Help make the expression in QlikView

Help make the expression

mikhail_sirik — Fri, 20 Apr 2018 08:35:28 GMT

Dear, Experts

Help formulate an expression for the MagicExpression column.

The values should be equal to the sum of the values of the field S where D1 is greater than max(D2), for each P.

I tried the expression sum({<D1={">$(=Date(max(D2)))"}>} S) but this is not correct

YoussefBelloum — Fri, 20 Apr 2018 08:49:27 GMT

EDITED:

Hi,

try this:

Sum({<D2={"$(=Max(Date(D2)))"}>}Aggr(Sum({<D2={"$(=Max(Date(D2)))"}>}S),P))

sunny_talwar — Fri, 20 Apr 2018 09:05:09 GMT

I don't think this can be done using set analysis... try this

Sum(Aggr(If(D1 > Max(TOTAL <P> D2), Sum(S)), P, D1))