Skip to main content
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.