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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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