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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Dec
Creator II
Creator II

Qlik Sense Accumulated date in expression form beginning of the year to today

Hi, I need to sum sales by accumulated date in expression.

I have data from the period 2019-2023, but I need to filter them in the query only to: 
- the current year
- from 01.01 to the present day
And I know, the current year would be enough, but the graph cannot react to any other filters related to days/weeks/months/date etc.

My current expression:
Sum( {<$(=year(today()))>} Sales)

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
Labels (6)
1 Solution

Accepted Solutions
Sebastian_Dec
Creator II
Creator II
Author

My solutions in edit expression:

Sum({<MonthNbr={"$(= '=' & (Max(MonthNbr)))"}, Year={"$(=(Max(Year)))"}, Day={"$(= '<=' & (Max(Day)))"}, Data=>} sales)

 

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
Sebastian_Dec
Creator II
Creator II
Author

My solutions in edit expression:

Sum({<MonthNbr={"$(= '=' & (Max(MonthNbr)))"}, Year={"$(=(Max(Year)))"}, Day={"$(= '<=' & (Max(Day)))"}, Data=>} sales)

 

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.