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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple Set Analysis Question

I am trying to find the sum of all charges for the last date posted regardless of any selections.  Currently I am working with this formula and striking out.  Does anyone have any tips?

=Sum({1<[Charges.POST_DATE]={$(=Max(Charges.POST_DATE))}>} [Charges.CHG_AMT])

Thanks!

1 Solution

Accepted Solutions
Not applicable
Author

Oh sorry I didn't see it at first.

Looks like the set statement for POST_DATE doesn't recognized the date value properly so I forced the value with the following statement.

Sum({<POST_DATE= {'$(=Date(MAX({1}POST_DATE),'YYYY-MM-DD'))'}>}CHG_AMT)

Hope this helps.

View solution in original post

4 Replies
Not applicable
Author

Looks like that should work. 

Do you have a sample data set you can pass on?

Not applicable
Author

I added it to my original message

Thanks!

Not applicable
Author

Oh sorry I didn't see it at first.

Looks like the set statement for POST_DATE doesn't recognized the date value properly so I forced the value with the following statement.

Sum({<POST_DATE= {'$(=Date(MAX({1}POST_DATE),'YYYY-MM-DD'))'}>}CHG_AMT)

Hope this helps.

Not applicable
Author

No you didn't miss it, I added it after you asked for the data!

It worked perfectly!

THANK YOU SO MUCH!