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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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