Load Data in qliksense based on selections in other app

[vishal_goyal]

Hi, 

I am using Qlik sense Enterprise version (Feb 2019 release). What I am looking for is allow users to make some selections in AppA and Load data in AppB based on selections made in AppA. The reason being for such use case if AppB contains transactional data and volume is huge . I don't want to load the entire data in AppB as this may impact the performance of other apps also. 

Hence I want user to choose what data he needs from AppA and then the scheduled job will load that data from AppB. 

AppA contains only dimension table to allow selection. 

AppB contains transactional data based on selection made in AppA. 

Just wondering how to achieve that. 

Any help is much appreciated. 

[lironbaram]

hello 

there is a bulit in solution in Qlik sense , called ODAG(on demand app generation ) 

that was created exactly for this use case 

check out those demos 

qlik help on the topic ODAG

discussion about this topic from the community 

[vishal_goyal]

Thank you Lironbaram,

My requirement is slightly different. My input is raw static and historical transaction data consists of approx 500 million records with each row having 350 columns. The output is also expected to be raw data but filters applied thus reducing the output to few thousand rows. I don't have to aggregate the data to generate output. 

I understand ODAG works with drill levels with aggregates applied. Sorry if I am wrong in my understanding of ODAG.

[paulcalvet · Accepted solution]

Hello,
I think you can achieve this with ODAG.
Aggregates data is not mandatory to use ODAG
ODAG allows an application to pass variables to another application and reload data.
ODAG is used to create the "WHERE" part in a request.
Paul

[vishal_goyal]

Thank you all for your help. Will try to use ODAG