Create 2 qvd's with same data but for different dates

[Prajna]

Hi,

 I have an application in qlikview in which we load data for 14 days. Ideally we maintain 2 years worth of data in qvd's but we load just data for 14 days in the app. Now i need to load certain columns from these existing qvd's for every tuesday (for 2 years) to display them in a trend graph.

 For eg:.,  So Suppose i have 30 columns in a single day's qvd, for the trend graph I need to pick out only 10 columns out of 30 from these qvd's  for a span of 2 years. The other 14 days of data that we load in the app will have all the columns loaded.

Now i am unable to figure out how to create an association between these 2 tables as i want the default filters in my  dashboard to  work on the trend graph as well. I want the app to display only 14 days of data , but only in the trend graph i need to show 2 years worth of data. 

When i try to create an association between dates the app ends up showing 2 years of data (dates) instead of 14 days.

Is there a better approach of doing this ?

[Dalton_Ruer]

What a conundrum. You need to SHOW the data, but you don't really want the application to have the OVERHEAD of actually having all of the data. 

I think the simple solution is to build a simple application that contains nothing more than the data needed, and the TREND chart that shows 2 years of data.

Then use a Sense Media Box extension that allows you to show anything from the web inside of a Qlik Sense application. And simply use the URL for the Trend chart from your other application so you get to see the chart, but you don't have all of its data inside the application.  https://developer.qlik.com/garden/57a0b25204177e48f38a8031

Basically you are doing a Mashup, but inside a Qlik Sense application.