Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Combining Static Data With Dynamic

PastData:

MonthYear     TopClients

03/2010          .68

06/2010          .68

09/2010          .62

12/2010          .65

03/2011          .64

06/2011          .65

09/2011          .67

12/2011          .65

I create a Line Chart and use Count() function to calculate vlaues over time form another QVD file that contains data from Jan 2012 onwards.

I need to append above static data to the begining of the line chart (as it is) and show calculated values from 01/2012 onwards.

0 Replies