topic Max Month in QlikView

Max Month

rcorcoran — Mon, 16 Jun 2014 09:15:28 GMT

I am trying to get the current month as the YTD figure rather than a sum of the months to date.

The expression below is giving me a sum of Jan to current month even though i have max month in

Any suggestions would be great

Thanks

Rhona

=(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"<=$(Max(ReferredMM))"}>}ActualValue))

Sorry none of the suggestions seem to work they are all still bringing up the total of the months??

Message was edited by: Rhona Corcoran

alexandros17 — Mon, 16 Jun 2014 09:17:11 GMT

The correct sysntax is:

=(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={'<=$(=Max(ReferredMM))'}>}ActualValue))

let me know

tresB — Mon, 16 Jun 2014 09:18:46 GMT

Only for max month? Try:

=Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"$(=Max(ReferredMM))"}>}ActualValue))

Note: Removal of the '<' sign.

its_anandrjs — Mon, 16 Jun 2014 09:23:44 GMT

Try with and put = sign on the expresion

=(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"<=$(=Max(ReferredMM))"}>}ActualValue))

=(Sum({$<[Physio Wait >12 wks]={20},ReferredMM={"<$(=Max(ReferredMM))"}>}ActualValue))