Combining Direct Discovery and In Memory data

greeshmak — Tue, 21 Dec 2021 17:03:56 GMT

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.

Re: Combining Direct Discovery and In Memory data

Dalton_Ruer — Wed, 21 Apr 2021 15:01:20 GMT

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)

topic Re: Combining Direct Discovery and In Memory data in Connectivity & Data Prep

Combining Direct Discovery and In Memory data

Re: Combining Direct Discovery and In Memory data