topic Re: max function in QlikView

max function

upaliwije — Thu, 28 Sep 2017 12:29:36 GMT

I have written following expression which does not return any value. Have I made any error in it.

SUM({<MONTH={'$(<=max(MONTH)'}>}ACTUAL)

swuehl — Thu, 28 Sep 2017 12:33:03 GMT

Is MONTH a field with numeric values?

What does

=Max(MONTH)

return in a text box?

swuehl — Thu, 28 Sep 2017 12:33:59 GMT

In addition, it should look like

SUM({<MONTH={"<=$(=Max(MONTH))"}>}ACTUAL)

upaliwije — Thu, 28 Sep 2017 12:36:00 GMT

This is how I extract Month

Month(TRN_DATE) As MONTH,

sibusiso90 — Thu, 28 Sep 2017 12:42:21 GMT

=SUM({<MONTH={"<=$(=max(MONTH))"}>}ACTUAL)

sibusiso90 — Thu, 28 Sep 2017 12:42:48 GMT

Try the above and let's see how it goes.