topic Re: MAX ALL not working in set analysis in QlikView

MAX ALL not working in set analysis

ken_geren — Mon, 13 Feb 2017 16:52:13 GMT

need a total for only the last load of orders. What's the best way to get the last date. The Max ALL is not working.

Sum({<[Order History Import Date]= { '=Max(ALL [Order History Import Date])'} >} [Order History Open Dollars])

Anonymous — Mon, 13 Feb 2017 16:57:04 GMT

just try:

Sum({<[Order History Import Date]= { '$(=date(Max(ALL [Order History Import Date])))'} >} [Order History Open Dollars])

Anil_Babu_Samineni — Mon, 13 Feb 2017 16:57:50 GMT

Try this

Sum({<[Order History Import Date]= {'$(=Max(TOTAL [Order History Import Date]))'} >} [Order History Open Dollars])

Sum({<[Order History Import Date]= {'$(=Max([Order History Import Date]))'} >} TOTAL [Order History Open Dollars])

sunny_talwar — Mon, 13 Feb 2017 17:05:20 GMT

May be this:

Sum({<[Order History Import Date]= {"$(=Max({1} [Order History Import Date]))"}>} [Order History Open Dollars])

MarcoWedel — Tue, 14 Feb 2017 00:13:55 GMT

please post a sample application to demonstrate

thanks

regards

Marco