Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Join model data with local excel data

Hi Folks

Is it possible to join model data with local data uploaded by user ? 

What I want to achieve is to build an app which will have a functionality to load local excel data ( format would be fixed) by user.  Then the app will read one particular field of the excel and pass the values to model as filter .  Then the model would return data based on that selection . In essence I want to do a left outer join of uploaded data with another data source in system .

Is this something possible very easily in QlikView or Sense ?

Best Regards

Anindya

6 Replies

Re: Join model data with local excel data

In QlikView you might be able to do a partial reload to get something like this accomplished

Not applicable

Re: Join model data with local excel data

Thanks for your quick reply Sunny .   I see in QlikSense we have a functionality to drag and drop excel file .  But not sure if we can access that excel file in a script to achieve my goal .

Re: Join model data with local excel data

You mentioned QlikView or Qlik Sense? I don't know about Qlik Sense, but if you can provide a sample for QlikView, I might be able to help you out.

Best,

Sunny

Not applicable

Re: Join model data with local excel data

Preference would be QlikSense , but I am fine with QlikView too.  I want to provide an app to users which will allow them to browse and select an excel file to load and then say "Execute" my model.  "Execute" button would read the excel file , let's say a column "Material Number" and pass those material numbers to another query.  Now , in third step I want to do a left outer join of the uploaded excel file and query result and present the data to users.

I am quite new to Qlik so not able to gauge the complexity of this requirement. 

Thanks for your help .

Best Regards

Anindya

Re: Join model data with local excel data

I have worked on some samples before, see if those help:

Dynamic Partial Reload for data model ?

Multiple Partial Reloads

Not applicable

Re: Join model data with local excel data

Hi Sunny

I was able to load Excel data and access them within script .   Now, my intention is to take distinct values from one field in excel data and pass them to another query ( from another source via ODBC)  as filter .  But, it seems I am stuck here.    I can bring all the data from my second source and do a left outer join, but second source would be huge . So, that would not be an efficient approach

Best Regards

Anindya

Community Browser