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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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