topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

adiarnon — Tue, 26 Jan 2016 08:06:54 GMT

HI,

i have a problem with set analysis-

this is my expression

SUM({<For_Year={$(<=Max([SO YEAR L]))}>}SO_LINE_SALES_VALUE_USD)

do you know why this expression is not working?

if im not putting the < its working...

tnx,

adi

jonathandienst — Tue, 26 Jan 2016 08:17:29 GMT

That should be

SUM({<For_Year={"<=$(=Max([SO YEAR L]))"}>} SO_LINE_SALES_VALUE_USD)

jagan — Tue, 26 Jan 2016 08:17:47 GMT

Try like this

SUM({<For_Year={'<=$(=Max([SO YEAR L]))'}>}SO_LINE_SALES_VALUE_USD)

Regards,

Jagan.

sunny_talwar — Tue, 26 Jan 2016 08:28:36 GMT

This should also work:

Sum({<For_Year={$(='<=' & Max([SO YEAR L]))}>} SO_LINE_SALES_VALUE_USD)