topic Re: Load Data in qliksense based on selections in other app in App Development

Load Data in qliksense based on selections in other app

vishal_goyal — Sat, 16 Nov 2024 20:58:25 GMT

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.

Re: Load Data in qliksense based on selections in other app

lironbaram — Sun, 28 Apr 2019 06:12:44 GMT

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

Re: Load Data in qliksense based on selections in other app

vishal_goyal — Sun, 28 Apr 2019 07:36:04 GMT

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.

Re: Load Data in qliksense based on selections in other app

paulcalvet — Sun, 28 Apr 2019 16:02:39 GMT

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

Re: Load Data in qliksense based on selections in other app

vishal_goyal — Mon, 29 Apr 2019 12:46:02 GMT

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