topic Re: Join model data with local excel data in App Development

Join model data with local excel data

Tue, 30 Aug 2016 17:38:56 GMT

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

Re: Join model data with local excel data

sunny_talwar — Tue, 30 Aug 2016 17:55:17 GMT

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

Re: Join model data with local excel data

Tue, 30 Aug 2016 18:23:08 GMT

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

sunny_talwar — Tue, 30 Aug 2016 18:40:18 GMT

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

Re: Join model data with local excel data

Tue, 30 Aug 2016 18:54:29 GMT

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

sunny_talwar — Tue, 30 Aug 2016 19:40:03 GMT

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

Dynamic Partial Reload for data model ?

Multiple Partial Reloads

Re: Join model data with local excel data

Fri, 02 Sep 2016 13:51:37 GMT

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