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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How To Compare Sum(Sales) for two Timestamps

I am struggling to compare Sum(Sales) for two different timestamps. Need help. Thanks,Branislav

Example_StampDate.PNG

11 Replies
Not applicable
Author

Desn't seem to work

sunny_talwar

Since today's date expression is not the only one working, can you try this may be:

=Sum({<STAMP_DATE = {"$(=TimeStamp(Max(STAMP_DATE), 'YYYY MM DD hh:mm:ss TT'))"}>}NET_SALES)