Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ken_geren
Contributor III
Contributor III

MAX ALL not working in set analysis

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])

4 Replies
Anonymous
Not applicable

just try:

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

Anil_Babu_Samineni

Try this

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


OR


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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be this:

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

MarcoWedel

please post a sample application to demonstrate

thanks

regards

Marco