Combining Direct Discovery and In Memory data

[greeshmak]

Hi,

I am building an app in QlikSense and have requirement to load the data almost realtime. I used direct discovery and it works. In addition to this I am looking for a way to show the historical data as well by combining the in memory data that shows information until previous day and the direct query will bring data for today. I tried to concatenate the two but my visuals only show the data pulled by the direct query.

Is there a way to combine direct query data with in memory data using concatenate?

Or any other approach to achieve this? 

I do not want to trigger QMC task to reload multiple times a day as it will affect performance when data volume increases.

[Dalton_Ruer]

I'm just brainstorming while my fingers type. 

Could you build a ValueList that has all of your dates via a variable like:

vDates = Concat(DISTINCT {1} chr(39)&MyDateField&chr(39),',')

and then an expression for the measure that checks 

IF(ValueList(..all your dates....) = TodaysDate, FieldWithValueFromDirectQuery, OtherFieldFromHistoricalTable)