Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nbuchholz1
Contributor II
Contributor II

Charting Cumulative data with snapshot data over time in combo chart

Hi - I am looking to chart progress over time of two data sets on the same chart.  Using a relatable example, imagine you wanted to plot the number of Movies available on AppleTV, Netflix, and Amazon prime vs the consumption of that content.  

Your data gives you a snapshot of the movies available at the end of the week, but your usage data is cumulative giving you the total daily views. 

ProductDateMovies
Apple+09/11/20201000
Netflix09/11/20204889
Amazon Prime09/11/202082299
Apple+09/04/20201888
Netflix09/04/202082992
Amazon Prime09/04/20202888
Apple+8/28/20202899
Netflix8/28/20202347
Amazon Prime8/28/20207992

 

ProductDateUsage
Apple+09/11/20201400000
Netflix09/11/20202800000
Amazon Prime09/11/2020450000
Apple+09/10/2020219900
Netflix09/10/20201899999
Amazon Prime09/10/2020178299

 


How would you plot this in Qliksense to get smooth lines? 
If the dimension is Date, and measures are sum(Movies) and sum(Usage), how do you plot this so you get smooth lines and ignore the dates where you don't have movie data. 

chart.JPG

 
 

 

 

Labels (4)
0 Replies