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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
breheme
Contributor
Contributor

Add Time Series Values After Some Date

Hello, experts. This is easy in python or other programming language. Basically I have two time series S1 and S2 with dates as dimension. I have also created a variable where the user can select a date. In a line graph I'm trying to show S1  and then another line that has S1 plus the values of S2 after the given date. I have tried the following set expression:

=sum(S1) + sum({<Date=">=$(given_date)">} S2)

However it seems that it add the entire S2 series to S1 and ignores the date parameter. Please let know if I need to add more detail or if you have any ideas. Thanks!

Labels (1)
0 Replies